namedBindings.js

var bind = function (str, vars) { 
   return str.replace(/(^|[^\\])\:(\w*)/g, function (v, w, x) { 
     return w + vars[x] 
   }) 
}


var query = bind('INSERT INTO table1 SER field1 = :field1, field2 = :field2 ON DUPLICATE KEY UPDATE field2 = :field2', {field1: 1, field2: 2}))

conn.query(query);