Updating records based on reference table

[mattiaz9]

How can I achieve this prisma example in drizzle:

await prisma.Member.updateMany({
  where: {
    corporation: {
      domain: "mycorp",
    },
  },
  data: {
    role: "admin",
  },
})

In this example domain is a field inside Corporation and I don't have direct access to it in the Member table.
In drizzle I can't innerJoin in an update function, so how can I do it? (without making multiple queries)

[AndriiSherman]

@mattiaz9 yeah we have it in roadmap
You can track this ticket here