with node v4 this becomes possible without any external library to do the es6 stuff.

es6-sql-poc.js

function param (name, type) {
  return {name: name, type: type};
}

function sql (template) {
  //this line goes away entirely with the ...spread operator, the function becomes `sql (template, ...values)`
  var values = Array.prototype.slice.call(arguments, 1);

  //console.log("template", template);
  //console.log("values", values);

  return {
    sql: template.slice(1).reduce((acc, part, i) => {
        return acc + '@' + values[i].name + part
      }, template[0]),
    params: values
  };

}

function run () {

  var output = sql`
    SELECT 
      * 
    FROM 
      foo 
    WHERE 
      x = ${param('x', 'VarChar')} 
    OR
      y = ${param('y', 'Int')};
    `;

  console.log(output.sql);
  console.log(output.params);

}

run();