SQL CTE Generator

Generate Common Table Expressions (CTEs) for all 5 SQL dialects. Simple WITH clauses, recursive hierarchies, running totals, and multi-CTE queries — copy-ready output.

CTE Settings

Recursive CTEs are ideal for hierarchical data like org charts, file systems, and bill-of-materials.

Generated Query

Configure settings and click Generate to see the CTE query.

Need to diff two schemas and generate migrations?

SchemaLens compares SQL schemas, detects breaking changes, and generates safe forward + rollback migrations — all in your browser.

Try SchemaLens Free