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 vote235 views1 answer
Ms sql unique
SQL
1 vote217 views1 answer
Mssql string length
SQL
15 votes261 views7 answers
MYSQL
SQL
0 vote260 views1 answer
Get number of rows in every table mysql
SQL
0 vote274 views1 answer
.sql File Run in PSQL
SQL
0 vote295 views1 answer
How to check rollback status in oracle
SQL
0 vote232 views1 answer
Import sql mysql ubuntu
SQL
0 vote242 views1 answer
Mysql begin statement
SQL
1 vote256 views1 answer
Insert column after column mysql
SQL
4 votes289 views1 answer
Rename stored procedure in sql server
SQL