divineomega/laravel-natural-where

Laravel Natural Where extends the Laravel query builder to allow expressing of where operators in natural language.

v2.1.0 2020-09-10 09:25 UTC

Requires

• php: >=7.1
• laravel/framework: ^5.6||^6.0||^7.0||^8.0

LGPL-3.0-only

• Jordan Hall

README

Laravel Natural Where extends the Laravel query builder to allow expressing of where operators in natural language.

Installation

To install Laravel Natural Where, run the following command from the root of your project.

composer require divineomega/laravel-natural-where

Usage

See the basic usage example below.

$query = \App\User::query()
    ->naturalWhere('created_at', 'is between the years', ['2018', '2020'])
    ->naturalWhere('email', 'contains the word', 'jordan')
    ->naturalWhere('name', 'is not', 'Jordan Smith')
    ->naturalWhere('id', 'is one of the following', [1, 2, 3])
    ->get();

This example will produce the following SQL query.

select * from `users` where (`created_at` >= '2018' and `created_at` <= '2020') 
and `email` LIKE '%jordan%' and `name` != 'Jordan Smith' and `id` in (1, 2, 3)