I think some of this is due to SQL frameworks becoming a must-have. Which is kind of fine, I guess, because it's certainly nicer to have your objects coming back to you in some known format rather than manually massaging raw row responses.

But at the same time, a fairly basic SQL query I could bang out in two minutes becomes an exercise in acrobatics & research in how to do it right in this version of this particular framework.