Upsert with Knexjs and MySQL

knexjsUpsert.js

const insert = knex('tableName').insert({
  ...newObj,
  id: uuidv4(),
  created_at: knex.fn.now(),
  updated_at: knex.fn.now()
});

// create string of raw update column parameters (e.g. field1=value1, field2=value2)
const rawUpdateParameters = Object.keys(updateObj)
  .map((field) => `${field}=${updateObj[field]}`)
  .join(', ');

knex.raw('? ON DUPLICATE KEY UPDATE ?', [
    insert,
    knex.raw(rawUpdateParameters)
]);

// The raw query essentially translates to MYSQL query:
// INSERT INTO tableName VALUES (x, y)
//   ON DUPLICATE KEY UPDATE field1=value1, field2=value2;

I think that string values should be enclosed by single quotes to avoid MySQL's ER_BAD_FIELD_ERROR error.

const record = {
  foo: 'foo',
  bar: "It's bar"
}

const insert = knex.insert(record).into('tableName')

const values = Object.entries(record)
    .map(([column, value]) => db.raw('?? = ?', [column, value]))
    .join(', ')

const query = db.raw(`${insert} ON DUPLICATE KEY UPDATE ${values}`)

console.log(query.toString())

insert into `tableName` (`bar`, `foo`) values ('It\'s bar', 'foo') ON DUPLICATE KEY UPDATE `foo` = 'foo', `bar` = 'It\'s bar'

Thank you for your good knowledge.