3 ms·
This, if you want to go the dynamic SQL route, please do it using some decent glue language or templating system that is not SQL itself. Unless you hate yoursel
by mrbungie 3y ago
This, if you want to go the dynamic SQL route, please do it using some decent glue language or templating system that is not SQL itself. Unless you hate yourself that is.
- rickboyce 3y agoFor 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/