staudenmeir/eloquent-eager-limit-x-laravel-cte
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.
|
Package
|
Score
|
Description
|
Stars
|
Likes
|
Forks
|
Downloads
|
Issues
|
Score
|
Opportunity
|
License
|
Last Release
|
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| staudenmeir/eloquent-eager-limit | 0.89 | Add per-parent limits to eager-loaded Eloquent relationships in Laravel. Load only the latest N related models for each parent (e.g., newest comments per post) without N+1 queries. Supports common relations and integrates cleanly with queries and pagination. | 883 | 884 | 70 | 40K | 0 | 12.5 | 23.0 | MIT | 3 years ago | |
| staudenmeir/eloquent-eager-limit-x-laravel-adjacency-list | 0.89 | 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 | |
| staudenmeir/eloquent-param-limit-fix | 0.88 | 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 | |
| staudenmeir/eloquent-param-limit-fix-x-laravel-adjacency-list | 0.88 | Bridge package that lets staudenmeir/laravel-adjacency-list work with the eloquent-param-limit-fix, avoiding database parameter limits when recursive adjacency list queries generate large numbers of bindings. | 11 | 11 | 0 | 49 | 0 | 6.7 | 10.3 | MIT | 8 months ago | |
| staudenmeir/laravel-upsert | 0.88 | Extends Laravel's upsert capabilities with support for custom unique indexes, ignoring duplicate inserts, and bulk updates across MySQL, PostgreSQL, SQLite, and SQL Server. Adds insertIgnore/insertOrIgnore helpers for dependable insert-or-update queries without extra boilerplate. | 315 | 315 | 32 | 5K | 0 | 2.8 | 17.4 | MIT | 4 years ago | |
| staudenmeir/laravel-merged-relations | 0.88 | Merge multiple Laravel Eloquent relations into a single relation that can be queried and eager loaded as one. Combine hasMany, belongsToMany, and morph relations into a unified result set, simplifying complex relationship handling in your models. | 185 | 186 | 12 | 53K | 1 | 9.6 | 36.2 | MIT | 7 months ago | |
| staudenmeir/laravel-cte | 0.87 | 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. | 669 | 669 | 51 | 817K | 0 | 20.5 | 45.0 | MIT | 8 months ago | |
| biiiiiigmonster/hasin | 0.87 | biiiiiigmonster/hasin brings recursive "has in" relationship queries to Laravel's Eloquent ORM, letting you fetch ancestors, descendants, and other nested tree data with fluent, hasMany-style syntax instead of raw recursive SQL. Ideal for category trees, comment threads, and org charts. | 154 | — | 17 | — | 0 | 9.8 | 0.4 | MIT | 7 months ago | |
| staudenmeir/eloquent-has-many-deep | 0.86 | 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 | |
| sbamtr/laravel-query-enrich | 0.86 | 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 | |
| fico7489/laravel-eloquent-join | 0.86 | Laravel Eloquent Join adds SQL JOIN support to Eloquent models and relationships, letting you sort, filter, and query joined tables directly while keeping familiar query builder syntax. It simplifies complex relationship queries and helps avoid extra queries. | 338 | — | 87 | — | 11 | 7.6 | 4.1 | MIT | 1 year ago |
|
| tpetry/laravel-query-expressions | 0.86 | 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 | — | |
| mouadziani/laravel-query-inspector | 0.86 | Laravel Query Inspector lets you see the SQL your app actually runs—log queries with bindings, execution time, and where they came from. A lightweight debugging aid for spotting slow, duplicate, or unexpected database calls during development. | 56 | — | 4 | — | 0 | 0.4 | — | MIT | 5 years ago | |
| kobykorman/eloquentify | 0.86 | Eloquentify turns one custom SQL query with JSON-aggregated relations into fully hydrated nested Eloquent models, collapsing N+1 and R+1 round trips into a single query with zero configuration. | 20 | 20 | 0 | 457 | 0 | 13.6 | 20.7 | MIT | 4 months ago | |
| staudenmeir/laravel-adjacency-list | 0.86 | Laravel Eloquent extension that adds recursive relationships for tree and graph structures using common table expressions (CTEs). Traverse categories, page hierarchies, nested comments, and more across MySQL, PostgreSQL, SQLite, SQL Server, and MariaDB. | 1,578 | 1,579 | 113 | 469K | 5 | 40.6 | 40.8 | MIT | 1 month ago | |
| protonemedia/laravel-eloquent-where-not | 0.86 | Adds whereNot and orWhereNot methods to Laravel Eloquent, letting you negate simple conditions, nested closures, and relationships cleanly. A small, expressive package for readable inverse WHERE clauses without raw SQL or awkward operator flipping. | 28 | 26 | 1 | 198 | 0 | 0.2 | 8.7 | MIT | 4 years ago | |
| korridor/laravel-has-many-merged | 0.86 | Adds a hasManyMerged relationship to Laravel Eloquent, letting you combine several hasMany relations across models into one query-backed collection with sorting, limits, and eager loading. Ideal for unified feeds, timelines, and activity lists. | 90 | 90 | 3 | 7K | 4 | 13.1 | 30.4 | MIT | 6 months ago | |
| reinink/advanced-eloquent | 0.85 | — | 574 | 578 | 23 | 15K | 1 | 2.1 | 14.0 | — | 7 years ago | |
| darrylkuhn/dialect | 0.85 | Dialect is a Laravel package for managing translations in the database. It scans your app for missing keys, provides a web UI for adding and editing translations, and helps keep localization strings organized without manually editing language files. | 126 | — | 24 | — | 0 | 1.7 | — | MIT | 5 years ago | |
| stancl/laravel-hasmanywithinverse | 0.85 | Laravel's hasMany leaves the inverse relation unset, so accessing the parent from each child triggers extra queries. This package adds hasManyWithinverse, which hydrates the inverse automatically—so $child->parent is already loaded without N+1. | 69 | — | 5 | — | 1 | 0.9 | — | MIT | 3 years ago |
How can I help you explore Laravel packages today?