News for hackers. Stuff that matters.

A comment on The Curse and Blessings of Dynamic SQL. Parent comment

Re:The Curse and Blessings of Dynamic SQL by mrbungie on Tuesday May 09, 2023 @02:23AM (#35870802)
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.
[ Parent | on HN ]
Re:The Curse and Blessings of Dynamic SQL by rickboyce on Tuesday May 09, 2023 @04:40AM (#35871633)
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/

[ Parent | on HN ]