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 votes141 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote157 views1 answer
Mysql show create db
SQL
4 votes170 views2 answers
Oracle unliock account
SQL
2 votes153 views1 answer
Sql string starts with
SQL
7 votes134 views1 answer
Append column sql
SQL
5 votes172 views3 answers
Sql limit offset
SQL
4 votes193 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote144 views1 answer
Mysql local password denied
SQL
6 votes144 views2 answers
Oracle trigger
SQL
0 vote202 views1 answer
How to show current database in mysql
SQL