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

2 votes186 views1 answer
Mysql how to store lat,lng
SQL
0 vote175 views1 answer
Suse start MySQL
SQL
0 vote225 views1 answer
Dual in db2
SQL
1 vote189 views1 answer
Psql connections
SQL
0 vote192 views1 answer
Oracle array
SQL
3 votes193 views1 answer
Ms sql skip take
SQL
0 vote192 views1 answer
Select from another database
SQL
23 votes198 views1 answer
How remove column in mysql
SQL
7 votes182 views1 answer
Grant schema permissions postgres
SQL
0 vote202 views1 answer
Restart sql server command line linux
SQL