What is the recommended way to reuse SQL statements?

[oskarrough]

Hello, was wondering what the recommended way to reuse SQL statements is here. I assumed sql${query}`` would work, but reading the docs I (maybe) I understand it's not meant to.

const query = 'select * from posts'
await sql`${query}` // throws an error
await sql.unsafe(query) // works

To avoid using the unsafe method, would you wrap everything in functions?

const queryById = (id) => sql`select * from posts where id = ${id}`
await queryById(42) // works

[porsager]

Oh yeah 😉 Functions Baby 🏋

[oskarrough]

tak!