I think you'll see the whole range of responses, even some very reasonable defenses of ORMs for some cases. I've come to prefer a yesql type approach that pars

I think you'll see the whole range of responses, even some very reasonable defenses of ORMs for some cases. I've come to prefer a yesql type approach that parses your sql into functions and provides a mechanism for applying functions to the bound data before running and the returned data after. Keeps things nicely separated and you can unit test your sql functions as application code.