Download the PHP package sbamtr/laravel-query-enrich without Composer
On this page you can find all versions of the php package sbamtr/laravel-query-enrich. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download sbamtr/laravel-query-enrich
More information about sbamtr/laravel-query-enrich
Files in sbamtr/laravel-query-enrich
Package laravel-query-enrich
Short Description A helper for Laravel eloquent and query builder
License MIT
Informations about the package laravel-query-enrich
Laravel Query Enrich
Supports Laravel 8, 9, 10, 11
Introduction
Laravel Query Enrich makes it easy to create complex database queries in Laravel without having to write complicated SQL code. It simplifies the way developers interact with databases, making it more straightforward to build and read queries in Laravel applications. With Query Enrich, you can achieve advanced database operations without the need for extensive SQL knowledge.
Benefits of Using Laravel Query Enrich:
No Hard Query Code
You don't have to struggle with complicated SQL. Laravel Query Enrich makes your queries simpler.
Ensures Cross-Database Compatibility
If you decide to switch the database engine, Laravel Query Enrich eliminates the need for manual code refactoring. It handles the difference between different database engines and makes things switch smoothly, all without needing programmers to do anything!
Easy-to-Read Code
Your code becomes cleaner and easier to understand. Laravel Query Enrich makes interacting with databases in your Laravel applications a breeze.
Example Usage
Look at the following examples. They are way cooler with the Laravel Query Enrich. Aren't they? :)
Categorize books into different price categories (using case when)
With Laravel Query Enrich
Without Laravel Query Enrich
Raw SQL
Fetch orders placed in the last 7 days
With Laravel Query Enrich
Without Laravel Query Enrich
Raw Query
Get average monthly price for oil and gas (using avg function)
With Laravel Query Enrich
Without Laravel Query Enrich
Raw Query
Fetch authors and check if they have any books (using exists query)
With Laravel Query Enrich
Without Laravel Query Enrich
Raw Query
Getting full name on database level (using concatws)
With Laravel Query Enrich
Without Laravel Query Enrich
Raw Query
Installation and documentation
The complete documentation is available here:
https://laravel-query-enrich.readthedocs.io/
License
The MIT License (MIT). Please see the License file for more information.
Written with ♥ by Siavash Bamshadnia.
Please support me by staring this repository.
All versions of laravel-query-enrich with dependencies
illuminate/database Version ^8.0|^9.0|^10|^11
illuminate/support Version ^8.0|^9.0|^10|^11
illuminate/contracts Version ^8.0|^9.0|^10|^11