The second step is easy, but I’m not sure how to do the first one.. another way would be to just findMany and update them individually, but I think it would be much faster if I could solve it in one query?

@Nichita Z 👋 Unfortunately the 1st isn’t possible at the moment. It would be great if you could add a 👍 on this request so that we can look at the priority 🙂 The workaround would be a raw query via

$queryRaw

for now.

The feature you are looking for is this https://github.com/prisma/prisma/issues/5013 As a workaround you can use the raw api https://www.prisma.io/docs/concepts/components/prisma-client/raw-database-access Or before the

comment.updateMany

you can fetch the last value of pending content.

Great, thank you!!

Thanks for helping out, Divy 😄 💚