Equivalent to NOT ($where) in SQL
NOT ($where)
This just wraps the passed in where clause.
Equivalent to AND in SQL
AND
Equivalent to OR in SQL
OR
Emits a scalar boolean SQL fragment using json_extract (no LATERAL joins). Used when this Where appears inside a CASE expression branch where row-level dispatch is required.
json_extract