The "deployment and versioning" piece is definitely solvable with the right tooling. Imperative migration tools are the wrong approach there, but declarative tools can offer a workflow very similar to how you version and deploy any other code.

I wrote about my open source solution for doing so in MySQL/MariaDB here: https://www.skeema.io/blog/2023/10/24/stored-proc-deployment...