A helper function to build queries with ES6 template strings in node-mysql.
"use strict";
//require the node mysql module
let mysql = require("mysql");
//require the es6 query file and pass the mysql.escape fn
let SQL = require( "sql"))(mysql.escape);
//now you can write SQL in front of the ES6 Template Strings and they get escaped
connection.query(SQL`SELECT username, password
FROM account
WHERE username = ${username}
LIMIT 1`, (err, rows) => {
//more code
});