A small query builder to help not writing SQL insert by hand

small-query-builder.js

const withQuotes = (value, quote = '\'') => {
  if (typeof value === 'undefined') {
    return 'null'
  }

  if (value === null) {
    return 'null'
  }

  return `${quote}${value}${quote}`
}

const getInsert = (table, columns = []) => {
  const columnsWithQuotes = columns.map((c) => withQuotes(c, '"'))
  const insert = `INSERT INTO ${table} (${columnsWithQuotes}) VALUES `
  const values = []

  return {
    withValues: (...data) => {
      data = Object.assign(...data)

      const value = columns.map((column) => {
        return withQuotes(data[column])
      }).join(', ')

      values.push(`(${value})`)
    },

    sql: () => {
      return insert + values.join(', ') + ';'
    }
  }
}

Example

const insert = getInsert('table', ['columnA', 'columnB'])

insert.withValues({columnA: 'hello', columnB: 'world'})
insert.withValues({columnA: 'answer is', columnB: '42'})

console.log(insert.sql())

Will print:

INSERT INTO table ("columnA", "columnB") VALUES ('hello', 'world'), ('answer is', '42');