Does Prisma support filtering with IN by tuples, e.g.:

SELECT * FROM table
WHERE (letter, number) IN (('T', 7), ('R', 2))

where table is:

number | letter
  7    |   'T'
  2    |   'R'
  4    |   'T'

if not, joined workaround?

Try like this:

prisma.table.findMany({
  where: {
    OR: [
      {
        letter: 'T',
        number: 7,
      },
      {
        letter: 'R',
        number: 2,
      },
    ],
  },
});

The above translates to:

SELECT * FROM table
WHERE (letter = 'T' and number = 7) or (letter = 'R' and number = 2)

which is not quite the same from an execution plan perspective.

Hmm I have thought it is the same, sorry I'm not an SQL expert.

@Oleg Komarov 👋 Currently you would need to use a raw query as tuples are not supported. It would be great if you could create a feature request so that we can look into this.

@Ryan Did it a couple of days ago, let me know if I need to add detail