Function buildContainmentClause

apps/sim/lib/table/sql.ts:456–459

Builds JSONB containment clause: `data @> '{"field": value}'::jsonb` (uses GIN index)

(tableName: string, field: string, value: JsonValue)

/** Builds JSONB containment clause: `data @> '{"field": value}'::jsonb` (uses GIN index) */
function buildContainmentClause(tableName: string, field: string, value: JsonValue): SQL {
  const jsonObj = JSON.stringify({ [field]: value })
  return sql`${sql.raw(`${tableName}.data`)} @> ${jsonObj}::jsonb`
}

/**
 * Builds a typed range comparison against a JSONB cell.