Extended the filtering system to allow for operators other than "=" and converted existing queries to use the new form. The new syntax look like:
Extended the filtering system to allow for operators other than "=" and converted existing queries to use the new form. The new syntax look like:

$filters = [
    "field" => "value",
    "integer" => ["op" => "<", "value" => 10],
    "float" => [
        ["op" => ">", "value" => 1.2],
        ["op" => "<=", "value" => 0.8],
    ]
]

Any valid SQL operator is allowed e.g. "LIKE"
For "IN", the value should be an array
Also, in the example above, the filters for "float" could be rewritten using "BETWEEN" like so:

[
    "float" => ["op" => "between", "value" => [0.8, 1.2], "inverted" => true]
]
// equates to 'NOT float BETWEEN 0.8 AND 1.2'

silktide/reposition