SQL is a living, breathing technical debt. So what I'm envisioning in your environment is that you've just shifted your problems from a functional OO language

SQL is a living, breathing technical debt. So what I'm envisioning in your environment is that you've just shifted your problems from a functional OO language to... SQL, which is neither. And when those queries evolve into the unmanageable beasts that they almost always do, what then? At least with languages that have sensible means for code organization you can break them out into things like TFA is discussing. SQL -- the language -- is shit, and this is the emperor-wears-no-clothes of our industry. The belief that extensive use of SQL in application code is something all wizards should aspire for is just completely nonsensical.