Definition

Filter::field('name', [FilterType::IN]);

Array/Object Structure

target
string
required
value
array,min:1
required
value.*
string|int|float
required

Example

$filter = [
    'type'   => '$in',
    'target' => 'name',
    'value'  => ['Taylor', 'Otwell',]
];
$sql = Person::filter([$filter])->toRawSql();

SQL

select * from "people" where "people"."name" in ('Taylor', 'Otwell')

Modifiers

Null

select *
from "people"
where (
    "people"."name" in ('Taylor', 'Otwell')
        or
    "people"."name" is null
)