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

1 vote287 views1 answer
How to update date add hours in postgresql
SQL
0 vote290 views3 answers
Magento 2 order delete from db
SQL
0 vote304 views1 answer
Mysql listing get a particu particular user firsdt
SQL
6 votes326 views2 answers
Subtr Oracle ?
SQL
0 vote303 views1 answer
Sql today at midnight
SQL
2 votes295 views2 answers
Mysql find max value row
SQL
-1 vote297 views1 answer
Concat two columns in sql server
SQL
2 votes334 views1 answer
Mysql select true or false
SQL
0 vote293 views1 answer
How to get parent and child record in single query using sql
SQL
1 vote302 views1 answer
Drop column if exists sql server
SQL