Laravel Cte Laravel Package

Laravel CTE adds Common Table Expressions (CTEs) to Laravel’s query builder and Eloquent, making it easy to write readable, composable SQL with WITH clauses. Define expressions using a query builder instance, raw SQL, or a closure, and use them seamlessly in SELECT and data-modifying queries.

Built for broad database support and multiple Laravel versions, it enables clean patterns for hierarchical queries and advanced SQL features without leaving Laravel’s fluent API.

• SELECT CTEs via withExpression() with builder/SQL/closure inputs
• Recursive CTEs for trees, graphs, and hierarchies
• Materialized expressions (where supported)
• Works with INSERT/UPDATE/DELETE queries
• Supports MySQL/MariaDB/PostgreSQL/SQLite/SQL Server/Oracle/SingleStore