Isn't one of the main reasons to move logic into the database is so that you have a dedicated DBA handling everything in the best way possible ?
I see old-school DBAs as people you give logical schema to, and they make the physical schema fast and keep the system up. That role feels pretty dated.