Between Columns

Filter::field('price', [FilterType::BETWEEN_COLUMNS]);

$filter = [
    'type'   => '$betweenColumns',
    'target' => 'price',
    'value'  => [
        'min_allowed_price',
        'max_allowed_price',
    ],
];

$sql = Product::filter([$filter])->toRawSql();

select
  *
from
  "products"
where
  "products"."price" between "products"."min_allowed_price"
  and "products"."max_allowed_price"