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

3 votes167 views2 answers
How to modify rows in SQL Server
SQL
0 vote135 views1 answer
How to move a columns location in mysql
SQL
0 vote141 views1 answer
Sql: extract day text from datetime value
SQL
0 vote149 views1 answer
Oracle calculate statistics on partition
SQL
3 votes173 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote144 views1 answer
Select sql in descending order
SQL
0 vote140 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote144 views1 answer
Postgres sql alter table delete row
SQL
0 vote153 views1 answer
Postgresql log
SQL
2 votes133 views1 answer
Postgresql update sequence next value
SQL