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.