Yesql

const sql = require('yesql')('/myproject/sql/',  {type: 'pg'})
const named = require('yesql').pg
const pg = require('pg').connect...

// read from file
pg.query(sql.updatePokemon({price: 5}), (err, result) => {...})

// use only named parameters
pg.query(named('UPDATE pokemon SET price = :price;')({price: 5}), (err, result) => {...})

Source: npmjs.com

Similar codes

0 vote264 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote275 views1 answer
Laravel eloquent get generated sql
SQL
-1 vote266 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
7 votes325 views1 answer
Show line number in sql server
SQL
4 votes284 views1 answer
Datepart postgres
SQL
5 votes301 views1 answer
Oracle add time to date
SQL
5 votes292 views1 answer
Sysdate in oracle sql
SQL
0 vote288 views1 answer
Sqlalchemy query sql compiled
SQL
7 votes303 views4 answers
Index in mysql
SQL
11 votes296 views3 answers
How to get last row of table in sql
SQL