Bulk update in Postgres w/ Drizzle ?
I'm using PSQL and would really like if Drizzle supported bulk updates out-of-the-box.
I've looked at the docs - but the only option I've seen is an
UPSERT (ie. insert w/ onConflictDoUpdate) statement which I'm not fan of for this use case.
I'd really like to be able to do a .update(table).set(arrayOfObjects) ! But it looks like it's not supported.
I'm thinking about doing an UPDATE FROM statement for PSQL leveraging sql from Drizzle but can't make it work somehow.
Any idea ?
Thank you !0 Replies