• composeSql is an ES template literal tag which converts an string template and variables into a postgres query object.

    const name = 'Geoff'

    composeSql`
    SELECT id, name, age
    FROM users
    WHERE name != ${name}
    and age < ${42}
    `

    becomes:

    {
    text: '\n SELECT id, name, age\n FROM users\n WHERE name != $1\n and age < $2\n',
    values: [ 'Geoff', 42 ]
    }

    Parameters

    • strings: TemplateStringsArray
    • Rest ...values: any[]

    Returns {
        text: string;
        values: any[];
    }

    • text: string
    • values: any[]

Generated using TypeDoc