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

UPSERT

UPSERT

UPSERT (ie. insert w/

onConflictDoUpdate

onConflictDoUpdate

onConflictDoUpdate

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)

.update(table).set(arrayOfObjects)

.update(table).set(arrayOfObjects)

.update(table).set(arrayOfObjects) ! But it looks like it's not supported.

I'm thinking about doing an

UPDATE FROM

UPDATE FROM

UPDATE FROM

UPDATE FROM statement for PSQL leveraging

sql

sql

sql

sql from Drizzle but can't make it work somehow.

Any idea ?

Thank you !

No replies yetBe the first to reply to this messageJoin