Earlier quoted context omitted.
Uh, doesn't everything you do with a database reduce to CRUD? I understand that sometimes you do the composition of many CRUD operations, but this is still CRUD.
Not at all. RDBMS features were critical in getting performance and scale once upon a time. Sharding, access control, authentication, indexed views, fk relationships and other constraint enforcement, cascading updates and deletes, efficient data management with stored procs, caching, etc etc. My first job was even writing dynamic web apps entirely in Informix.
Do you think of better ways to handle this nowadays? Is it more effective/maintainable to do this in the app layer?