CTE Common Table Expression
SQL construct WITH foo AS (SELECT ...) that lets you name intermediate results in a query.
Makes complex queries readable — builds up in steps instead of nested subqueries. Also recursive CTEs for tree structures (org charts, comment threads). Modern SQL standard feature since 2008.