SQL's recursive common table expressions (CTEs) have a questionable reputation: verbose, awkward to read, inefficient to evaluate, ungrokkable semantics, ripe with arbitrary syntactic restrictions, and basically stale for 25 years now (since their advent in SQL:1999). Ugh.
3 months ago