There is sqlmesh which implements some nice concepts like blue green deployments.

https://sqlmesh.readthedocs.io/en/latest/