plain equality
{ status: "done" }
json_extract(_doc, '$.status') = ?
q.eq
{ priority: q.eq("high") }
json_extract(_doc, '$.priority') = ?
q.ne
{ status: q.ne("archived") }
json_extract(_doc, '$.status') != ?
q.oneOf
{ status: q.oneOf(["done", "reviewing"]) }
json_extract(_doc, '$.status') IN (?, ?)
q.notOneOf
{ status: q.notOneOf(["archived", "deleted"]) }
json_extract(_doc, '$.status') NOT IN (?, ?)
q.gt
{ score: q.gt(80) }
json_extract(_doc, '$.score') > ?
q.gte
{ progress: q.gte(50) }
json_extract(_doc, '$.progress') >= ?
q.lt
{ retryCount: q.lt(3) }
json_extract(_doc, '$.retryCount') < ?
q.lte
{ dueAt: q.lte(to) }
json_extract(_doc, '$.dueAt') <= ?
q.between
{ updatedAt: q.between(from, to) }
json_extract(_doc, '$.updatedAt') BETWEEN ? AND ?
q.exists
q.exists("assignee")
json_type(_doc, '$.assignee') IS NOT NULL
q.missing
q.missing("deletedAt")
json_type(_doc, '$.deletedAt') IS NULL
q.empty
q.empty("removedAt")
json_extract(_doc, '$.removedAt') IS NULL OR json_extract(_doc, '$.removedAt') = ''
q.has
{ tags: q.has("urgent") }
EXISTS (SELECT 1 FROM json_each(json_extract(_doc, '$.tags')) WHERE value = ?)
q.contains
{ title: q.contains("release") }
json_extract(_doc, '$.title') LIKE ?
q.all
q.all({ project }, { status: "active" })
(json_extract(_doc, '$.project') = ?) AND (json_extract(_doc, '$.status') = ?)
q.any
q.any({ status: "done" }, { status: "reviewing" })
(json_extract(_doc, '$.status') = ?) OR (json_extract(_doc, '$.status') = ?)
q.not
q.not({ status: "archived" })
NOT (json_extract(_doc, '$.status') = ?)
q.when true
q.when(userIds.length, { user: q.oneOf(userIds) })
json_extract(_doc, '$.user') IN (?, ...)
q.when false
q.when(false, { user })
1 = 1
nested path
{ "profile.city": "Seoul" }
json_extract(_doc, '$.profile.city') = ?
array field
{ watchers: q.has(userId) }
EXISTS (SELECT 1 FROM json_each(json_extract(_doc, '$.watchers')) WHERE value = ?)
q.raw
q.raw("json_extract(_doc, '$.score') > ?", [minScore])
(json_extract(_doc, '$.score') > ?)
