CTE (Common Table Expression)

SQL

A temporary named result set defined with the WITH clause. CTEs improve readability and can be recursive. In PostgreSQL 12+, non-recursive CTEs can be inlined by the optimizer.