Function buildEmptyClause

apps/sim/lib/table/sql.ts:559–565

* Builds an emptiness check against a JSONB cell. `isEmpty` matches null cells * (absent key or JSON null, both surfaced as SQL NULL by `->>`) and empty * strings; the negation requires the cell to be present and non-empty.

(tableName: string, field: string, isEmpty: boolean)

 * strings; the negation requires the cell to be present and non-empty.
 */
function buildEmptyClause(tableName: string, field: string, isEmpty: boolean): SQL {
  const escapedField = field.replace(/'/g, "''")
  const cell = sql.raw(`${tableName}.data->>'${escapedField}'`)
  return isEmpty
    ? sql`(${cell} IS NULL OR ${cell} = '')`
    : sql`(${cell} IS NOT NULL AND ${cell} <> '')`
}

/**
 * Builds a single ORDER BY clause for a field.