4 ms·
the library recommends you do that this way const query = SQL`SELECT * FROM books` if (params.name) { query.append(SQL` WHERE name = ${params.name}`)
by voxic11 3y ago
the library recommends you do that this way
const query = SQL`SELECT * FROM books`
if (params.name) {
query.append(SQL` WHERE name = ${params.name}`)
}
query.append(SQL` LIMIT 10 OFFSET ${params.offset || 0}`)
or if you need raw values like a table name then just pass append a string.
db.query(SQL`SELECT * FROM "`.append(table).append(SQL`" WHERE author = ${author} ORDER BY ${column} `).append(order))