A JSONLogic expression used to filter search results.
Supports operators: ==, !=, >, >=, <, <=, contains, match, in, every, and, or.
- contains: LIKE substring matching
- match: FTS5 full-text search (requires virtual table join)
- in: ANY semantics (at least one match)
- every: ALL semantics (must match every value, uses GROUP BY + HAVING)
Field references use {"var": "fieldName"} for single-table queries
or {"var": "alias.fieldName"} for multi-table queries with JOINs.