@vercel/postgres - can't do 'SELECT x WHERE id IN' query about edge-config HOT 2 CLOSED

Right now, you'll have to fall back to creating the query and calling sql.query yourself -- SQL templating is very limited:

const query = 'SELECT * FROM users WHERE id IN ($1, $2, $3)'
const params = [1234, 2345, 3456]
await sql.query(query, params)

However, when/if #504 merges, something like this will be possible:

await sql`SELECT * FROM users WHERE id IN (${LIST(params)})`

So hopefully you don't have to manually build more-complex queries for too long!

from edge-config.

That TQL syntax looks great, would happy to see it merged.
For now, thanks a lot for the response, I appreciate it :)

from edge-config.