As someone working at a company that decided to write most of their SQL code at the application layer, there are definite tradeoffs. Our application performance suffers because of the fear of vendor lock-in and the flexibility others thought that writing code at the application level would provide.
The question I pose to anyone consider this type of architecture is, how often do you switch database platforms?
The question I pose to anyone consider this type of architecture is, how often do you switch database platforms?