How do you handle deploys of SQL related things in a CI/CD way?

Sqitch. DB migrations for multiple data stores without a proprietary syntax for DB updates. Git-aware. Integrated unit testing. https://sqitch.org/ https://youtu.be/wF4PEe8HD7k

Dbt