a big loop of

.upsert

calls is a bottleneck in my app, so I'm trying to switch to either

createMany

with ignoring duplicates, or

queryRaw

. I'm hitting the issues that (1) there's no

upsertMany

. (2)

createMany

doesn't return the duplicated rows and

updateMany

doesn't let you specify multiple

where

conditions, and (3)

queryRaw

doesn't appear to support arrays-of-arrays as arguments. This is a bit of a bummer. I'm trying to just have some raw SQL in this part of my app because the ORM-unoptimized version is not sufficient, but the queryRaw bit doesn't seem to work either for this usecase.

I wrestled with this recently too

i was able to make a little progress, by dropping down to lower levels of the stack

ahh, tricky. This is a really tough use case -- Prisma does so many things well, but it hurts to have to drop to raw SQL strings for batch updates, when you may not have to with some other ORMs (that are deficient in other ways!)

okay, finally got it in!

Thanks for sharing!

zip

here is the lodash zip method, which changes an array of [a, b, c] into arrays of [a, a, a], etc, then you unnest that into a list of rows you select from, cast, etc