laravel-query-builders

Type-safe custom query builders in Laravel are created by extending Illuminate\Database\Eloquent\Builder with a dedicated class, encapsulating complex query logic to improve IDE autocomplete and reduce errors. You then register this builder with your Eloquent model.

Register a custom Eloquent builder with a Laravel model using the #[UseEloquentBuilder(OrderBuilder::class)] attribute in Laravel 11+, or by setting the protected static string $eloquentBuilder property. This automatically routes model queries to your custom class.

The best way to organize reusable Eloquent queries is encapsulating them in composable builder classes. This approach centralizes query logic within dedicated builders, preventing code duplication across controllers and services while maintaining type safety.

Yes, you can use nested and fluent query composition by chaining custom methods like wherePending, whereCustomer, and withRelated on your builder classes. This allows you to build complex database queries seamlessly across models, controllers, and services.

This approach requires Laravel 11+ if you use attributes like #[UseEloquentBuilder] for model integration. However, you can achieve similar type-safe builder integration on older versions by using protected static string properties instead of PHP attributes.