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

54 votes333 views6 answers
Sql rename column
SQL
0 vote151 views4 answers
How to get max salary in each department in sql
SQL
4 votes178 views1 answer
Alter session set nls_date_format
SQL
0 vote142 views1 answer
Mysql repair a table
SQL
0 vote175 views1 answer
Mysql command line top 10
SQL
1 vote142 views4 answers
Get week day from date in sql
SQL
7 votes158 views6 answers
Group_concat in mysql
SQL
14 votes148 views2 answers
Install mysqldump
SQL
13 votes159 views4 answers
Command line mysql import
SQL
0 vote192 views1 answer
Sql developer format sql
SQL