JsonArray

JsonArray = "JSON_CONTAINS" | "JSON_NOT_CONTAINS"

Defined in: packages/@livestore/common/dist/schema/state/sqlite/query-builder/api.d.ts:133

Operators for checking if a JSON array column contains a value.

⚠️ Performance note: These operators use SQLite’s json_each() table-valued function which cannot be indexed and requires a full table scan. For large tables with frequent lookups, consider denormalizing the data into a separate indexed table.

See

https://sqlite.org/json1.html#jeach