Re:Literate SQL
by calpaterson on Saturday December 19, 2015 @02:20PM
(#10764528)
SQLAlchemy (which is sort of an embedded dsl for SQL) lets you give variable names to subqueries and as a result I don't really use CTEs. I bet the people using iBatis and JOOQ can do the same thing
[ Parent
| on HN ]
As far as using CTEs for structuring your SQL is concerned, you're right, unless people really want the side-effects CTEs sometimes have, such as materialisation in PostgreSQL.
But don't forget: CTEs can be recursive.