How to concatinate multiple partial statements about postgres HOT 2 CLOSED

This is hopefully something you can find through docs or searching issues.

This should do it :)

const conditions = [
  sql`age > 1`,
  sql`height < 170`,
  sql`hair_color = 'red'`
]

await sql`
  select * from humans where ${ conditions.flatMap((x, i) => i ? [sql`and`, x] : x) }
`

There a many ways to dynamically generate queries, so having all ways covered in the docs is not something I have time to do (or want to), as it is highly case specific. Perhaps a separate post explaining the difference between, values, identifiers and keywords relating to dynamic query generation would help, but again - unfortunately not something I have time to do.

from postgres.

bump bump

from postgres.