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 vote197 views1 answer
T sql return on letters only
SQL
25 votes216 views5 answers
Uninstall mysql ubuntu
SQL
0 vote231 views1 answer
Sparql if bound query
SQL
0 vote214 views1 answer
Safe mysql
SQL
0 vote187 views1 answer
Tsql generate rows
SQL
0 vote214 views1 answer
Group by 15 minute interval sql server
SQL
0 vote165 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
18 votes192 views4 answers
Foreign key mySql
SQL
2 votes229 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote192 views1 answer
Postgresql alter column nullable
SQL