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 vote149 views1 answer
Plsql trigger insert update
SQL
1 vote190 views1 answer
Postgres convert exisiting column to text
SQL
0 vote193 views3 answers
Drop multiple columns in sql
SQL
79 votes559 views6 answers
Grepper code
SQL
0 vote184 views2 answers
Sql select inside select
SQL
-1 vote140 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote201 views1 answer
Cast float mysql
SQL
2 votes231 views1 answer
Pandas to sql index
SQL
1 vote211 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote247 views1 answer
For select oracle
SQL