Filter your Illuminate\DataBase\Query\Builder using a structured query language.
This can be pretty usefull when you're building an API and you don't want to waste hours of your time creating predefined filters that may change at any time.
PHP 8.1 or later.
use Railken\LaraEye\Filter;
use Railken\SQ\Exceptions\QuerySyntaxException;
use App\Foo;
// Instance of Illuminate\DataBase\Query\Builder
$query = (new Foo())->newQuery()->getQuery();
$str_filter = "x > 5 or y < z";
$filter = new Filter("foo", ['id', 'x', 'y', 'z', 'created_at', 'updated_at']);
try {
$filter->build($query, $str_filter);
} catch (QuerySyntaxException $e) {
// handle syntax error
}
Syntax here
You can install it via Composer by typing the following command:
composer require railken/lara-eye
Open-source software licensed under the MIT license.
