Comment by rickboyce

For analytics work tools like dbt are really gaining traction for this reason.

Most of the OLAP / warehousing stuff I used to lean on dynamic sql for can be done more cleanly, with the benefit of easy source control.

https://www.getdbt.com/