Recursive CTE

Also written: WITH RECURSIVE

A CTE that refers to itself to build rows step by step, with an anchor and a recursive step joined by UNION ALL. It generates calendars and walks hierarchies like the staff org chart.