Query builder vs parameterized queries?

From my understanding, this is a parameterized query:router.post("/register", function(req, res){ console.log(req.body); bcrypt.hash(req.body.password, 10, function(err, hash){ if(err) return console.log(err); else{ req.body.password = hash; var sql = "INSERT INTO SCHEMA.user_authentication(first_name, last_name, email, password, age)" +"VALUES(?, ?, ? ,? ,?)" var values = [req.body.first_name,req.body.last_name, req.body.email,req.body.password,req.body.age] app.con.query(sql, values, function(err, result) { if(err) return console.log(err); console.log("1 record inserted"); }); } }); }); Then there are query builders like knex. My question is, what is the difference between them? readability? etc

Submitted August 15, 2017 at 02:51AM by badboyzpwns