It would be nice to see multiple WHERE, AND conditions get supported by prisma 2 queries. for non-unique values

You can use the

many

equivalent to obtain the same for non-unique values

thanks I will try it