staudenmeir/laravel-cte
Adds common table expression (CTE) support to Laravel's query builder and Eloquent. Use withExpression and withRecursiveExpression for SELECT, INSERT, UPDATE, and DELETE queries, including recursive and materialized expressions. Works with Laravel 5.5+ and major databases.
|
Package
|
Score
|
Description
|
Stars
|
Likes
|
Forks
|
Downloads
|
Issues
|
Score
|
Opportunity
|
License
|
Last Release
|
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ceddyg/query-builder-repository | 0.88 | ceddyg/query-builder-repository is a Laravel package that layers a repository abstraction over the fluent query builder, giving you a clean, reusable data layer for your models. It streamlines CRUD, filtering, and query organization so controllers and services stay lean, readable, and testable. | 11 | — | 7 | — | 3 | 1.0 | 0.4 | — | — | |
| staudenmeir/eloquent-eager-limit-x-laravel-cte | 0.88 | A Laravel package that combines eager limit loading with common table expressions, letting you limit eager-loaded relationships per parent model using CTEs. Useful for fetching only the latest or top N related records for each parent in a single query. | 6 | 6 | 2 | 415 | 0 | 0.4 | 24.6 | MIT | 3 years ago | |
| eghamat24/database-repository | 0.88 | A Laravel package that adds a database repository layer for wrapping Eloquent queries in reusable repository classes. It helps keep models and controllers clean, reduces duplicated query logic, and makes data access more organized, consistent, and testable for common database operations. | 19 | — | 9 | — | 4 | 1.7 | 0.8 | — | 1 year ago | |
| michael-rubel/laravel-sql-function-repository | 0.88 | A lightweight Laravel package that brings the repository pattern to SQL functions, letting you call database functions and stored procedures through clean, testable classes with bound parameters instead of scattered raw queries. | 7 | 7 | 1 | 0 | 0 | 0.2 | — | MIT | 3 years ago | |
| sbamtr/laravel-query-enrich | 0.87 | A Laravel package that adds expressive query enrichment helpers, letting you append computed values, relationships, and metadata to Eloquent results cleanly while reducing boilerplate and keeping data shaping close to your queries. | 142 | 142 | 6 | 878 | 1 | 12.9 | 13.0 | MIT | 5 months ago | |
| itul/sql-to-laravel | 0.87 | Convert raw SQL into Laravel query builder or Eloquent code. Paste a SQL query and generate equivalent Laravel syntax to speed up refactoring, debugging, and migrating legacy database logic into your application. | 0 | 0 | — | 393 | — | 0.0 | 35.9 | — | — | |
| tpetry/laravel-postgresql-enhanced | 0.87 | Laravel supports only the lowest common denominator of databases. This package unlocks PostgreSQL's full power: extensions, triggers, views, advanced indexes, zero-downtime migrations, and more. | 1,044 | 1,044 | 47 | 231K | 9 | 9.2 | 34.7 | MIT | — | |
| mouf/magic-query | 0.87 | Magic Query lets PHP developers describe SQL queries in JSON instead of hand-written strings, then compiles them into parameterized SQL with joins, unions and filters handled automatically. This reduces injection risk and makes complex queries easier to build, reuse and maintain across projects. | 20 | 21 | 14 | 4K | 4 | 2.1 | 33.8 | — | 1 year ago | |
| eg-mohamed/referenceable | 0.87 | Referenceable is a Laravel package that adds customizable reference numbers to Eloquent models. It offers random, sequential, and template-based generation with placeholders like {YEAR} and {SEQ}, plus collision handling, validation, multi-tenancy, and Artisan commands. | 87 | 87 | 3 | 1K | 0 | 18.2 | 17.3 | MIT | 3 months ago | |
| tpetry/laravel-query-expressions | 0.87 | Add powerful SQL expression support to Laravel’s query builder. Compose reusable, type-safe expressions for functions, casts, JSON ops, windows, and more, with clean syntax and cross-database compatibility—ideal for advanced filtering, sorting, and computed columns. | 357 | 359 | 29 | 118K | 1 | 2.9 | 34.8 | MIT | — | |
| staudenmeir/eloquent-has-many-deep | 0.87 | Extended HasManyThrough for Laravel 5.5+ lets you define relationships with unlimited intermediate models, supporting many-to-many, polymorphic, and combined relationship types. Define deep relationships by concatenating existing ones or specifying keys manually; includes third-party package support... | 2,872 | 2,876 | 157 | 943K | 2 | 36.4 | 36.8 | MIT | 7 months ago | |
| pannella/laravel-cti | 0.87 | — | 3 | 3 | 0 | 406 | 1 | 19.4 | 31.2 | MIT | 3 months ago | |
| beyondcode/laravel-ask-database | 0.87 | Ask your database questions in plain English. BeyondCode's package uses AI to translate natural language into SQL queries and returns the results, making data exploration easier without writing SQL yourself. | 301 | 276 | 46 | 92 | 0 | 1.6 | 1.1 | MIT | 3 years ago | |
| laravel-clickhouse/laravel-clickhouse | 0.87 | A ClickHouse database driver for Laravel with Eloquent models, Query and Schema builders, and native support for ClickHouse features like ARRAY JOIN, FINAL, PREWHERE, and lightweight deletes. Includes HTTP transports and migrations. | 232 | 232 | 19 | 31K | 1 | 23.4 | 34.5 | MIT | 1 week ago | |
| staudenmeir/eloquent-param-limit-fix | 0.87 | Laravel package that fixes "too many SQL variables" errors by automatically splitting large whereIn, insert, and update queries into batches that stay under your database's parameter limit. Works with SQLite, MySQL, PostgreSQL, and SQL Server. | 51 | 51 | 8 | 8K | 0 | 0.8 | 30.3 | MIT | 2 years ago | |
| ablunier/laravel-database | 0.87 | ablunier/laravel-database provides convenient database helpers for Laravel applications, simplifying connection management, schema operations, and common queries. Keep persistence logic clean and consistent with a lightweight package that integrates smoothly into your existing Laravel workflows. | 1 | 2 | 1 | 5 | 0 | 0.0 | 7.5 | — | 9 years ago | |
| genealabs/laravel-optimized-postgres | 0.87 | GeneaLabs Laravel Optimized Postgres brings PostgreSQL-specific performance enhancements to Laravel's query builder and Eloquent, helping you write faster queries and better use native Postgres features. A lightweight drop-in for apps already running Postgres. | 58 | 58 | 1 | 9K | 0 | 16.3 | 34.6 | MIT | 2 months ago | |
| knobik/sql-agent | 0.86 | Self-learning text-to-SQL agent for Laravel that turns natural language into accurate SQL using knowledge bases, memory, and live schema context. Includes SQL safety guardrails and a built-in chat UI. | 19 | 17 | 3 | 58 | 0 | 20.2 | 9.4 | Apache-2.0 | 2 months ago | |
| staudenmeir/laravel-migration-views | 0.86 | Laravel Migration Views adds createView and dropView macros to Laravel's schema Blueprint, letting you create and drop database views directly in migrations alongside your tables. Supports MySQL, PostgreSQL, SQLite and SQL Server. | 226 | 226 | 18 | 100K | 0 | 8.3 | 38.6 | MIT | 8 months ago | |
| staudenmeir/eloquent-eager-limit-x-laravel-adjacency-list | 0.86 | Compatibility package combining staudenmeir/laravel-adjacency-list with eloquent-eager-limit, letting Laravel apps cap eager-loaded relations on recursive adjacency list queries. Adds the missing trait support so hierarchical models can limit eager loads per parent without N+1 queries. | 14 | 14 | 1 | 403 | 0 | 0.4 | 20.0 | MIT | 3 years ago |
How can I help you explore Laravel packages today?