PostgreSQL prepared statements via ES6 Template Literals (string interpolation)
Usage
const prepare = ; ...const firstName = 'Foo';const lastName = 'Bar'; let stmt = prepare`SELECT ::text AS first_name, ::text AS last_name`;console; //{ text: 'SELECT $1::text AS first_name, $2::text AS last_name', values: ['Foo', 'Bar'] } let result = await client;console; //{ first_name: 'Foo', last_name: 'Bar' }
See also: