Legible? Absolutely. But it&#x27;s important to keep in mind that CTE&#x27;s are optimization fences. Optimizations like predicate pushdown are not currently available. More complicated queries may benefit from being rewritten with subqueries.