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 do

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/ https://www.getdbt.com/