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

2 votes370 views2 answers
Mysql count rows returned
SQL
-1 vote360 views1 answer
Mysql select count if contains
SQL
0 vote318 views1 answer
Count column of tables psql
SQL
2 votes368 views1 answer
Oracle block
SQL
0 vote367 views1 answer
Mysql show category once count how many products
SQL
2 votes395 views2 answers
Create temporary table in mysql
SQL
13 votes334 views4 answers
Mysql select last 10 rows
SQL
0 vote368 views1 answer
Migration graphql
SQL
0 vote381 views1 answer
Oracle grant create job
SQL
0 vote354 views1 answer
Android sqlite add column if not exists
SQL