typed-sql-query

This library is partial rewrote of sql-template-strings to add type support to the generate query config

This helper generates a postgres’s QueryConfig object for the given query

$3

``bash
npm install typed-sql-query
`

$3

`ts
import { sql } from 'typed-sql-query'

interface IResult {
id: number
name: string
}

const filter = sqlWHERE id = ${1}
const query = sqlSELECT id, name FROM table ${filter};
const client = await pgPool.connect()
const result = await client.query(query)

const query2 = sqlSELECT * FROM table ORDER BY ${sql.raw('created_at')}

const conditions = [sqlid = ${1}, sqlid = ${2}]
const query3 = sqlSELECT * FROM table WHERE ${sql.join(conditions, 'AND')}

``

$3

ISC License

Copyright (c) 2016, Felix Frederick Becker (original author)

Copyright (c) 2020, Tan, Shiaw Uen