Common Table Expressions in CockroachDB

A Common Table Expression (CTE) is a named result set of a query that exist temporarily for use within the context of a larger query. CTEs are commonly used to increase the readability of complex queries by decomposition and reusable blocks. In addit...