Filtering with 'where: { fieldName: { in: ['value1', 'value2'] } } Not Supported

[SteveKekacs]

I have a simple user table with an encrypted email field (and corresponding emailHash field), and need to be able to filter users where their email is in a list of emails (see below).

This is returning 0 results, because filtering with the in clause isn't implemented.

model User {
  ...
  email     String? @unique /// @encrypted
  emailHash String? @unique /// @encryption:hash(email)
}

const getUsersByEmails = async (emails: string[]) => {
  // This returns 0 results, despite their being users with matching emails
  return prisma.user.findMany({
    where: { email: { in: emails } }
  });
}