Function coerceEmptyFlag

apps/sim/lib/table/sql.ts:545–552

* Coerces a `$empty` operand to a boolean. Accepts a real boolean (the UI path) * and the string forms `'true'` / `'false'` (lenient raw-API input). Anything * else throws rather than silently inverting the check — a 400 with a clear * message beats returning the opposite row set.

(field: string, value: unknown)

 * message beats returning the opposite row set.
 */
function coerceEmptyFlag(field: string, value: unknown): boolean {
  if (typeof value === 'boolean') return value
  if (value === 'true') return true
  if (value === 'false') return false
  throw new TableQueryValidationError(
    `$empty on column "${field}" requires a boolean, got ${typeof value}`
  )
}

/**
 * Builds an emptiness check against a JSONB cell. `isEmpty` matches null cells