Hey @rishi556 ! It is a really good question. I prefer to do all the work possible inside SQL because you will optimize the speed of your program and reduce the number of database calls.
For example, I used it to create recurrent events inside a Store Procedure. Instead of doing 20 requests from your app to your database for every recurring event, you will have only one request to your database, because this is the SQL that will do all the job; the loop and insert data in the table. The time your user gain creating a recurrent event is game-changing!
Sorry for my English, I hope I answered well to your question 🌻