Laravel Eloquent Query Filter using Pipeline

One of the features of Laravel which surely useful is the pipeline. Pipelines is one of the most used components in the Laravel for example middleware.

Basically, with a pipeline we can pass an object through a stack of tasks and get the result via a callback.

The benefit of pipeline for query filtering is that we can reduce tons of lines to several lines. Being unaware of the pipelines, we would usually set up a controller, get an instance of Eloquent of User model, and apply some condition based on query string.

Let’s see below queries.

$query = User::query();
if ($request->username) {
    $query->where('username', 'LIKE', "%$request->username%");
}

if ($request->email) {
    $query->where('email', 'LIKE', "%$request->email%");
}
if ($request->address) {
    $query->where('address', 'LIKE', "%$request->address%");
}
if ($request->occupation) {
    $query->where('occupation', 'LIKE', "%$request->occupation%");
}
return $query->get();

The drawback is that, it’s obviously that filters conditions will continue to grow as well as duplication of the same filter for other query. In other hand, the maintainability of the code kind of headache.