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

11 votes99 views3 answers
Sqlite3 create table from another table
SQL
16 votes105 views1 answer
Mssql int max value
SQL
5 votes93 views2 answers
Add column postgres with default value
SQL
1 vote108 views1 answer
Oracle sql average
SQL
0 vote100 views1 answer
Windows services sql
SQL
5 votes93 views2 answers
Oracle list columns schema
SQL
0 vote107 views1 answer
Dapper run sql script with parameters
SQL
-1 vote106 views1 answer
How to change the auto increment in existing table mysql
SQL
6 votes104 views2 answers
Mysqldump password in file
SQL
0 vote111 views1 answer
Oracle NLS_CHARACTERSET
SQL