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 vote329 views2 answers
Procedure pl/sql
SQL
0 vote358 views1 answer
St_buffer mysql
SQL
7 votes373 views3 answers
Postgresql dump and restore db
SQL
4 votes366 views3 answers
Sql drop primary key
SQL
14 votes360 views3 answers
Alter foreign key
SQL
4 votes404 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
-1 vote332 views1 answer
Mysql coalesce
SQL
0 vote328 views1 answer
Dump only schema
SQL
0 vote337 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
1 vote352 views1 answer
Get the User Name and Domain Name from an Email Address
SQL