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.