Just learn how to use Liquibase (or flyway, or... ) in your git repo and CICD pipeline deployments alongside your code.
I did it with production Scala apps over a decade ago. I even built sproc TDD test suites.
I did it with production Scala apps over a decade ago. I even built sproc TDD test suites.
But... over the years, I've seen push to sprocs where the logic was never version controlled or subject to the same level of testing the regular app source code was. The DBA folks had total control and were treated as a separate class of engineer than mere 'app' engineers, which caused all sorts of problems...