ic syntax (https://www.postgresqltutorial.com/postgresql-recursive-query/):</li>
</ul>
<pre><code>WITH RECURSIVE cte_name AS(
    CTE_query_definition -- non-recursive term
    UNION [ALL]
    CTE_query definion  -- recursive term
) SELECT * FROM cte_name;</code></pre>
<ul>
<li>CTE: <em>common table expression</em></li>
<li>Since recursive queries are (of course) recursive, we need a <em>base case</em>, called a <em>non-recursive term</em> here</li>
<li>Then we need 1 or more recursive terms</li>
<li><code>