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

3 votes128 views1 answer
Oracle undo tablespace schema
SQL
0 vote116 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
1 vote108 views1 answer
Copy postgres table from one schema into another
SQL
3 votes106 views2 answers
Oracle synonym
SQL
0 vote109 views1 answer
Sqlalchemy sequence postgresql
SQL
3 votes133 views1 answer
RENAME table pl sql
SQL
0 vote108 views4 answers
Mysql count table rows
SQL
3 votes110 views1 answer
Mysql insert on dupèlicate
SQL
13 votes112 views6 answers
Current date sql
SQL
0 vote107 views1 answer
Calculate date and convert to yearsmysql
SQL