Add support for parameterized queries about squel HOT 5 CLOSED

I just added pull request #34 for this functionality (initially compatible with node-postgres).

from squel.

Squel does support parameterized queries, using the usingValuePlaceholders option, see in http://hiddentao.github.io/squel/#update

I think I need to add a top-level section to the docs for parameterized queries to make this clearer to people.

from squel.

Well sure, you can do this:

var query = squel.update()
  .table("students")
  .set("name", "$1")
  .set("gender", "$2")
  .toString();

// node-postgres client
client.query({ text: query, values: ['Thomas', 'M'] });

But using my pull request you can do

var query = squel.update()
  .table("students")
  .set("name", "Thomas")
  .set("gender", "M")
  .toParam();

// node-postgres client
client.query(query);

which is much easier to read and maintain.

from squel.

👍

from squel.

Version 2.0.0 now has the toParam() method included from #34

from squel.