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 vote213 views1 answer
Sql auto date
SQL
11 votes235 views3 answers
How to get last row of table in sql
SQL
0 vote222 views1 answer
Install squirrel sql ubuntu
SQL
2 votes217 views2 answers
Compare date mysql
SQL
0 vote222 views2 answers
Jsonb
SQL
0 vote230 views1 answer
SQL server datetime compare
SQL
7 votes229 views4 answers
Lowest salary in sql
SQL
1 vote195 views3 answers
Remove unique key from a table
SQL
1 vote233 views1 answer
How to subtract from the value of a table in sql
SQL
18 votes225 views6 answers
Creating table in MySQL
SQL