Function jsonbCastForType

apps/sim/lib/table/sql.ts:40–49

* Returns the Postgres cast needed to compare a JSONB text value of the given * column type, or `null` when text comparison is correct. Single source of * truth for both filter range operators and sort ordering — keeps the two * paths from drifting apart.

(type: ColumnType | undefined)

 * paths from drifting apart.
 */
function jsonbCastForType(type: ColumnType | undefined): 'numeric' | 'timestamptz' | null {
  switch (type) {
    case 'number':
      return 'numeric'
    case 'date':
      return 'timestamptz'
    default:
      return null
  }
}

/**
 * Maps a column's **stable id** (the JSONB storage key, via `getColumnId`) to