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

5 votes387 views1 answer
Oracle ora-00054 find
SQL
0 vote331 views1 answer
Sql delete row from table where id
SQL
0 vote351 views2 answers
Greater than sql server
SQL
3 votes338 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote337 views1 answer
Report in database
SQL
1 vote346 views1 answer
Mysql data from file
SQL
1 vote331 views1 answer
Show table status command in mysql
SQL
3 votes319 views2 answers
Oracle sql drop sequence
SQL
1 vote380 views1 answer
Floor function in sql oracle
SQL
0 vote350 views1 answer
Mysql calculated column
SQL