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

0 vote126 views3 answers
Joins and views sql
SQL
0 vote119 views1 answer
Luu ckeditor vao mysql
SQL
0 vote124 views1 answer
Mysql change timestamp on update
SQL
13 votes114 views2 answers
Check if value is null mysql
SQL
51 votes259 views6 answers
Installing mysql on ubuntu
SQL
0 vote123 views1 answer
How to tell if i have lactose intolerance
SQL
24 votes128 views4 answers
Mysql datetime
SQL
1 vote102 views1 answer
Update from select join
SQL
0 vote102 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote112 views1 answer
How to check default value of column in sql server
SQL