I used to avoid things like stored procedures like the plague, because of my fear that crucial business logic would end up outside of version control.

These days I'm comfortable enough driving EVERY database change through a version controlled migration system (usually Django migrations) that I'm not concerned about this any more. It's not hard to enforce version controlled migrations for this kind of thing, provided you have a good migration system in place.