Code Weaver

Helps Laravel developers discover, compare, and choose open-source packages. See popularity, security, maintainers, and scores at a glance to make better decisions.

Laravel Cte Laravel Package

staudenmeir/laravel-cte

Adds Common Table Expression (CTE) support to Laravel’s query builder and Eloquent. Build WITH and WITH RECURSIVE queries, materialized CTEs, custom columns and cycle detection, plus CTEs for insert/update/delete. Works across major databases (MySQL, Postgres, SQLite, SQL Server, Oracle).

View on GitHub

Deep Wiki

Context7

v1.13.0

What's Changed

Support Laravel 13 and drop Firebird support by @staudenmeir in https://github.com/staudenmeir/laravel-cte/pull/80

Full Changelog: https://github.com/staudenmeir/laravel-cte/compare/v1.12.4...v1.13.0

v1.12.4

What's Changed

Support custom Firebird connection resolvers (#78)

Full Changelog: https://github.com/staudenmeir/laravel-cte/compare/v1.12.3...v1.12.4

v1.12.3

What's Changed

refactor: improve grammar selection logic, fixes #74 by @f-liva in https://github.com/staudenmeir/laravel-cte/pull/75

New Contributors

@f-liva made their first contribution in https://github.com/staudenmeir/laravel-cte/pull/75

Full Changelog: https://github.com/staudenmeir/laravel-cte/compare/v1.12.2...v1.12.3

v1.12.2

What's Changed

Support Laravel 12 by @staudenmeir in https://github.com/staudenmeir/laravel-cte/pull/73

Full Changelog: https://github.com/staudenmeir/laravel-cte/compare/v1.12.1...v1.12.2

v1.12.1

What's Changed

Support Laravel 12 by @staudenmeir in https://github.com/staudenmeir/laravel-cte/pull/69

Full Changelog: https://github.com/staudenmeir/laravel-cte/compare/v1.12...v1.12.1

v1.12

What's Changed

Use PHP 8.4 by default by @staudenmeir in https://github.com/staudenmeir/laravel-cte/pull/64
Test Oracle coverage on PHP 8.3 by @staudenmeir in https://github.com/staudenmeir/laravel-cte/pull/65
Support Laravel 12 by @staudenmeir in https://github.com/staudenmeir/laravel-cte/pull/66

Full Changelog: https://github.com/staudenmeir/laravel-cte/compare/v1.11.2...v1.12

v1.11.2

What's Changed

Prepare for PHP 8.4
Increase PHPStan level by @staudenmeir in https://github.com/staudenmeir/laravel-cte/pull/60
docs: version compatibility by @AlanRezende in https://github.com/staudenmeir/laravel-cte/pull/61
Upgrade to PHPStan 2 by @staudenmeir in https://github.com/staudenmeir/laravel-cte/pull/62

New Contributors

@AlanRezende made their first contribution in https://github.com/staudenmeir/laravel-cte/pull/61

Full Changelog: https://github.com/staudenmeir/laravel-cte/compare/v1.11.1...v1.11.2

v1.11.1

What's Changed

Restore return type (#57)

Full Changelog: https://github.com/staudenmeir/laravel-cte/compare/v1.11...v1.11.1

v1.10.1

What's Changed

Restore return type (#57)

Full Changelog: https://github.com/staudenmeir/laravel-cte/compare/v1.10...v1.10.1

v1.11

What's Changed

Support Laravel 11

Full Changelog: https://github.com/staudenmeir/laravel-cte/compare/v1.10...v1.11

v1.10

What's Changed

Refactor ConnectionFactory to Use Match Expression by @usermp in https://github.com/staudenmeir/laravel-cte/pull/52
Support Firebird (#54)

New Contributors

@usermp made their first contribution in https://github.com/staudenmeir/laravel-cte/pull/52

Full Changelog: https://github.com/staudenmeir/laravel-cte/compare/v1.9...v1.10

v1.9

What's Changed

Add Oracle support by @staudenmeir in https://github.com/staudenmeir/laravel-cte/pull/50

New Contributors

@staudenmeir made their first contribution in https://github.com/staudenmeir/laravel-cte/pull/50

Full Changelog: https://github.com/staudenmeir/laravel-cte/compare/v1.8...v1.9

v1.8

What's Changed

Added support of the SingleStoreDB by @AdalbertMemSQL in https://github.com/staudenmeir/laravel-cte/pull/48

New Contributors

@AdalbertMemSQL made their first contribution in https://github.com/staudenmeir/laravel-cte/pull/48

Full Changelog: https://github.com/staudenmeir/laravel-cte/compare/v1.7.1...v1.8

v1.7.1

Support Laravel's new toRawSql() (#47)

v1.7

Support Laravel 10

v1.6.3

Support updateFrom() on PostgreSQL (#42)

v1.5.5

Support updateFrom() on PostgreSQL (#42)

v1.2.3

Support PHP 8

v1.6.2

Refactor code for merge packages

v1.6.1

Add cycle detection

v1.6

Support Laravel 9

v1.5.4

Return number of affected rows from insertUsing() (#37)
Call applyBeforeQueryCallbacks() in insertUsing()

v1.5.3

Support UPDATE and DELETE queries with joins or limit on PostgreSQL and SQLite

v1.5.2

Fix compatibility issues with custom query builders (#29)

v1.3.2

Fix compatibility issues with custom query builders (#29)

v1.5.1

Support expressions on outer UNION queries

v1.3.1

Support expressions on outer UNION queries

v1.5

Add materialized expressions

v1.4.1

Support PHP 8

v1.0.7

Support PHP 7.4

v1.4

Support Laravel 8

Weaver

How can I help you explore Laravel packages today?

Conversation history is not saved when not logged in.

Add packages to context

No packages found.

codraw/framework-extra-bundle

codraw/messenger

codraw/security

codraw/mailer

codraw/contracts

codraw/profiling

codraw/dependency-injection

codraw/tester

codraw/core

nexmo/api-specification

capell-app/block-library

axium/identity

cetria/laravel-dummy-models

cetria/reflection-helper

agropredict/sso-auth-bundle

evolvestudio/spam-protection

datacore/hub-sdk

develia/commons

cuci/prototurk-sdk

cuci/prototurk-sdk-symfony