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 vote330 views1 answer
Syntax for changing column size in mysql
SQL
1 vote349 views1 answer
Wherein mysql
SQL
0 vote365 views1 answer
How to print sql query
SQL
0 vote365 views1 answer
Sql query wordpress export post
SQL
0 vote337 views1 answer
Postgresql concat string with separator
SQL
12 votes342 views3 answers
Install sqlite driver ubuntu
SQL
-1 vote348 views2 answers
Installing mysql on centos 7
SQL
3 votes324 views1 answer
Oracle apex warn on unsaved changes
SQL
1 vote347 views1 answer
Oracle datafile max size 32gb
SQL
0 vote322 views1 answer
Oracle drop default value
SQL