The first company I ever worked for thought it was a good idea to have all business logic in stored procedures "for speed".

It worked. Except when you need to add BC breaking features.

The solution? Keep the legacy code in file do_something.sql and add the new functionality in do_something_1.sql.

It became a sordid game trying to find the highest postfix. My record was 16.