I work of one of those “everything must be a stored procedure companies.” We are stuck with a single rdbms vendor and the company is perfectly ok with this. Di

I work of one of those “everything must be a stored procedure companies.” We are stuck with a single rdbms vendor and the company is perfectly ok with this. Different developers have different skill levels and specialties but they know how to call stored procedures. We have DB admins and a team of SQL specialists who optimize things and make sure everything meets standards. Stored procedure code is source controlled just like other application code, just in different repos. No there aren’t unit tests on this, but integration tests at the application level provide some coverage. I realize there are downsides but they are generally acceptable. We aren’t really putting much if any domain logic in these stored procedures.