sqltag

SQL generation using ES6 tagged template strings for mysql / mysql2 and postgres.

install

``sh
npm install sqltag
`

basic usage

You can use ${} syntax for value interpolation.

`js
import SQL from 'sqltag'

mysql.query(SQLSELECT * FROM users WHERE id = ${15})
mysql.query(SQLSELECT * FROM users WHERE id = ${15} AND age > ${30})

pg.query(SQLSELECT * FROM users WHERE id = ${15})
pg.query(SQLSELECT * FROM users WHERE id = ${15} AND age > ${30})
`

extensions

$3

Raw values are inserted into resulting SQL as is.

`js
pg.query(SQLSELECT * FROM ${SQL.raw('users')} WHERE id = ${15})
`

$3

Identifiers are escaped according to database engine. Use for table / field names.

`js
pg.query(SQLSELECT * FROM ${SQL.ident('users')} WHERE id = ${15})
`

$3

`js
pg.query(SQLSELECT * FROM users ${SQL.where({ id: 15, name: 'foo' })})
pg.query(SQLSELECT * FROM users ${SQL.where({ id: 15, age: SQL.op('>', 30) })})
`

$3

`js
pg.query(SQLUPDATE users ${SQL.set({ name: 'foo', age: 40 })} WHERE id = ${33})
`

$3

`js
pg.query(SQLINSERT INTO users ${SQL.values({ name: 'foo', age: 40 })})
pg.query(SQLINSERT INTO users ${SQL.values([{ name: 'foo', age: 40 }, { name: 'bar', age: 50 }])})
`

$3

`js
pg.query(SQLSELECT * FROM users WHERE tags IN (${SQL.spread(['foo', 'bar', 'baz'])}))
``