Function generateSimpleInsertStatement

frontend/src/utils/v1/sql.ts:214–235

(
  engine: Engine,
  schema: string,
  table: string,
  columns: string[]
)

};

export const generateSimpleInsertStatement = (
  engine: Engine,
  schema: string,
  table: string,
  columns: string[]
) => {
  if (engine === Engine.MONGODB) {
    const kvPairs = columns
      .map((column, i) => `"${column}": <value${i + 1}>`)
      .join(", ");
    return `db["${escapeMongoDBCollectionName(table)}"].insert({ ${kvPairs} });`;
  }

  const schemaAndTable = generateSchemaAndTableNameInSQL(engine, schema, table);

  const columnNames = columns
    .map((column) => wrapSQLIdentifier(column, engine))
    .join(", ");
  const placeholders = columns.map((_) => "?").join(", ");

  return `INSERT INTO ${schemaAndTable} (${columnNames}) VALUES (${placeholders});`;
};

// MySQL-family engines use backtick identifiers, treat backslash as an escape
// character inside string literals, and render booleans as 1/0.