This Laravel extension adds support for common table expressions (CTE) to the query builder and Eloquent.

Supports Laravel 5.5+.

• MySQL 8.0+
• MariaDB 10.2+
• PostgreSQL 9.4+
• SQLite 3.8.3+
• SQL Server 2008+

composer require staudenmeir/laravel-cte:"^1.0"

Use this command if you are in PowerShell on Windows (e.g. in VS Code):

composer require staudenmeir/laravel-cte:"^^^^1.0"

• SELECT Queries
  • Recursive Expressions
  • Materialized Expressions
  • Custom Columns
  • Cycle Detection
• INSERT/UPDATE/DELETE Queries
• Eloquent
  • Recursive Relationships
• Package Conflicts
• Lumen

Use withExpression() and provide a query builder instance, an SQL string or a closure: