Postgres CTE

Common Table Expression

• Explicit compared to
  Postgres RLS

• A temporary result table created with the WITH clause, offering better readability than
  PostgreSQL Subquery

• Similar to subqueries in reusing result tables, but supports recursion

Postgres Recursive CTE

• nested operation