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 votes229 views1 answer
Mysql sysdate
SQL
0 vote233 views1 answer
How to output a different column name in mysql
SQL
0 vote209 views1 answer
Postgres create database if not exists
SQL
0 vote244 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
0 vote222 views6 answers
Unique key in sql
SQL
0 vote233 views1 answer
Find all tables where column name exists oracle
SQL
2 votes268 views1 answer
Coalesce sql
SQL
4 votes238 views1 answer
SQL find text in SP
SQL
7 votes258 views1 answer
Oracle pagination query rownum
SQL
1 vote212 views1 answer
Firebase bigquery cloud message
SQL