You should try it some time, the advantages become obvious. You can verify your SQL just by re-running a single sql script. You can use a simple script to auto-generate the functions in your app to access the stored procedures, including ensuring everything is type safe. You can update your logic without having to update your app. And there's literally no downside. I can't understand why anyone would want to keep their SQL in their app, it is horrible compared to keeping it in the DB.