Few more advantages: - Round-trips avoided. - Security. - Data integrity. The last two points rely on building a public API out of stored procedures / f

Few more advantages: - Round-trips avoided. - Security. - Data integrity. The last two points rely on building a public API out of stored procedures / functions / views and disallowing direct access to base tables. That ensures no one can access anything without proper authorization and no one can change the data unless in accordance to what stored procedures allow. It's just a shame that procedural extensions of SQL (T-SQL, PL/SQL and brethren) seem stuck in the '80s when it comes to developer experience.