function buildMultiInsert(table, columns, dataRows) {
  const header = "insert into " + table + ' (' +columns.join(',') +') values ';
  return {
    statement: header + buildParameters(columns, dataRows),
    parameters: buildValues(columns, dataRows)
  }
}

function buildParameters(columns, dataRows) {
  return dataRows.map((row,rowIndex)=>{
    return'(' + columns.map((c, i)=>{
      return "$" + ((rowIndex * columns.length) + i+1)
    }).join(', ') + ')'
  }).join(', ')
}

function buildValues(columns, dataRows) {
   const valuesArr = dataRows.map((row,rowIndex)=>{
    return columns.map((c)=>{
      return row[c]
    })
  })
  return [].concat.apply([], valuesArr);
}


buildMultiInsert('foo',['name', 'agr'], [{
  name: 'Brian',
  age: 31
}, {
  name: 'Aaron',
  age: 29
}] )