Function rowValueToSQLLiteral

frontend/src/utils/v1/sql.ts:271–319

(
  value: RowValue | undefined,
  engine: Engine
)

// stay bare, strings/JSON/timestamps are single-quoted and escaped, booleans
// follow the engine convention, and NULL is emitted for null/unset cells.
export const rowValueToSQLLiteral = (
  value: RowValue | undefined,
  engine: Engine
): string => {
  if (value === undefined || value.kind?.case === undefined) {
    return "NULL";
  }
  const { kind } = value;
  switch (kind.case) {
    case "nullValue":
      return "NULL";
    case "boolValue":
      if (isMySQLFamilyEngine(engine)) {
        return kind.value ? "1" : "0";
      }
      return kind.value ? "TRUE" : "FALSE";
    case "int32Value":
    case "uint32Value":
    case "doubleValue":
    case "floatValue":
      return String(kind.value);
    case "int64Value":
    case "uint64Value":
      return kind.value.toString();
    case "stringValue":
      return escapeSQLStringLiteral(kind.value, engine);
    case "bytesValue": {
      const hex = bytesToHex(kind.value);
      // Postgres-family bytea literal vs MySQL/MSSQL 0x literal.
      if (
        engine === Engine.POSTGRES ||
        engine === Engine.COCKROACHDB ||
        engine === Engine.REDSHIFT
      ) {
        return `'\\x${hex}'`;
      }
      return `0x${hex}`;
    }
    default: {
      // valueValue (JSON / composite), timestamps, and anything else fall
      // back to their plain display form, single-quoted.
      const plain = extractSQLRowValuePlain(value);
      if (plain === null || plain === undefined) {
        return "NULL";
      }
      return escapeSQLStringLiteral(String(plain), engine);
    }
  }
};

// generateInsertStatementFromRows builds a single batched INSERT statement for
// the given rows. Each `rows[i]` is the cell array of one result row, aligned