spatie/laravel-query-builder
Laravel Query Builder
Acest proiect este un wrapper de query builder Eloquent și un parser de query-uri REST API pentru aplicații Laravel. Acesta traduce parametrii cererilor HTTP în interogări de bază de date pentru a oferi filtrare dinamică, sortare și încărcarea relațiilor pentru endpoint-urile API.
Sistemul decuplează interfața API externă de stratul de stocare prin abstractizarea schemei bazată pe alias-uri, permițând numelor publice ale câmpurilor să fie mapate către coloane private ale bazei de date. Suportă includerea dinamică a relațiilor imbricate și a numărătorilor agregate, precum și execuția logicii programatice personalizate pentru filtre și sortare prin clase invokable și closure-uri.
Suprafața de capabilități acoperă proiecția datelor prin selecția câmpurilor și ordonarea rezultatelor pe baza parametrilor cererii. Oferă, de asemenea, mecanisme pentru filtrarea bazată pe relații folosind dot-notation, integrarea cu scope-urile modelelor locale și controlul asupra vizibilității înregistrărilor soft-deleted.
Features
- Eloquent Query Wrappers - Translates HTTP request parameters into complex database queries using the Eloquent ORM for Laravel applications.
- Query Parameter Filters - Translates URL query parameters into database filters supporting partial matches, exact matches, and logical groupings.
- Query Parameter Filters - Translates request parameters into complex database filters using AND/OR logical conjunctions.
- Dataset Filtering and Search - Provides mechanisms for end users to refine and search through large datasets using dynamic filters and logical groupings.
- Dynamic Relationship Loading - Loads specified relationships and nested relations based on parameters passed in the request.
- Dot-Notation Join Paths - Parses nested relationship identifiers using dot-notation to generate database JOIN clauses and filters.
- Field Selection - Limits the columns returned by a database query based on parameters specified in the request URL.
- Model Scope Integration - Maps URL filter parameters directly to local Eloquent model scopes.
- Association-Based Filters - Provides mechanisms to filter records based on attributes of their associated relationships using dot-notation.
- Eager Loading - Dynamically injects eager loading constraints into the query builder based on requested relation identifiers.
- Query Sorting - Orders query results based on request parameters, supporting multiple columns, directions, and fallbacks.
- Dynamic Relation Loaders - Dynamically includes nested database relationships and aggregate counts based on API request parameters.
- Dynamic Relationship Loading - Allows API clients to specify which nested relationships and aggregate counts should be included in the response.
- Query Builders - Translates HTTP request parameters into Eloquent database queries for API filtering, sorting, and including.
- Model Scoping - Triggers local Eloquent model scopes by mapping request parameters to predefined model-level query methods.
- Request-to-Query Predicate Mapping - Translates HTTP request parameters directly into database query predicates for dynamic filtering.
- Schema Abstraction Layers - Maps public API field names to private database column names to decouple the external interface from storage.
- API Query Filtering - Maps URL query strings to database constraints to provide dynamic data filtering for API endpoints.
- REST API Query Parsers - Builds API endpoints that allow clients to filter, sort, and include related data directly via URL query parameters.
- Field Aliasing - Hides internal database column names from API consumers by mapping request parameters to specific table fields.
- Custom Relationship Loaders - Supports executing custom closures or classes to modify the query builder when specific relationships are requested.
- Sort Field Aliasing - Maps request parameters to internal database columns to hide the underlying schema from API consumers.
- Relationship Count Aggregators - Attaches relationship counts and aggregate values from associated models to the primary result set.
- Soft-Delete Query Overrides - Allows API requests to override default soft-delete filters to include or exclude trashed records.
- Invokable Sorting Classes - Delegates complex ordering requirements to dedicated classes that manually modify the query builder's order clauses.
- Custom Sorting Logic - Implements arbitrary sorting logic via invokable classes for requirements like string length or raw SQL expressions.
- Closure-Based Query Constraints - Applies custom database constraints by executing registered closures when specific filter keys are detected.
- Complex Query Filtering Logic - Enables the execution of custom programmatic logic to apply complex constraints to the database query builder.
- Query Filtering Integrations - Implements advanced search and sorting logic within Laravel applications using declarative request-based rules.
