News for hackers. Stuff that matters.
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
Re:Literate SQL by lukaseder on Sunday December 20, 2015 @05:31AM (#10766682)
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.