Small. Fast. Reliable.
Choose any three.

recursive-cte

cte-table-name AS ( initial-select UNION ALL recursive-select ) UNION



References:   cte-table-name

See also:   lang_with.html