As far as using CTEs for structuring your SQL is concerned, you&#x27;re right, unless people really <i>want</i> the side-effects CTEs sometimes have, such as materialisation in PostgreSQL.<p>But don&#x27;t forget: CTEs can be recursive.