> My hunch is that the problems with stored procedures actually come down to > version control

Git? (and migrations)

> change management

Again. Just like any other code.

> and automated tests.

Just write an automated test like you write any other kind of test?

That's exactly what I'm saying. If you do those things stored procedures stop sucking.

It's also about separately scaling your business logic from the data layer