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 vote155 views1 answer
Provera dupliranih konatakata
SQL
3 votes124 views2 answers
Sql paging query
SQL
0 vote141 views1 answer
Codigo crear tablas sql server
SQL
0 vote140 views1 answer
Query to remove duplicate rows from a table
SQL
6 votes137 views3 answers
Create database mysql utf8
SQL
0 vote122 views2 answers
How to set global time_zone in mysql
SQL
0 vote131 views1 answer
Oracle procedure chain step
SQL
0 vote144 views1 answer
Sql out file formate
SQL
12 votes134 views1 answer
Script to add new column in table sql
SQL
3 votes118 views1 answer
Start mysql server linux terminal
SQL