I have to wonder if the code review process wouldn't be as big a deal if they hired a proper DBA. This problem would not have been an issue if the DBA had been told "we need to do X," and the DBA would craft a stored procedure for X.

I get that stored procedures aren't a cure-all, and sure, they can get out of hand, but doing this stuff in code is often worse than letting the DB do its job.