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 vote312 views1 answer
Sql query to select records entered in last 24 hours
SQL
1 vote321 views1 answer
Postgres concat_ws
SQL
4 votes373 views3 answers
Postgres drop all tables
SQL
0 vote330 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote341 views3 answers
Database restoring error
SQL
0 vote315 views1 answer
Flask sqlalchemy update row
SQL
0 vote332 views1 answer
Java nosql sort
SQL
1 vote369 views1 answer
Find size of all DB's postgres
SQL
0 vote316 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote353 views1 answer
What is database username and password in mysqliconnect
SQL