Any reason there isn't a

notEquals

?

notIn

is so convenient.

This is an interesting question, I'm also curious what the answer will be. My guess is that this has to do with the support for it across databases? For example, in PostgreSQL we have the

WHERE NOT EQUAL

clause. However to my knowledge of something like MySQL, there isn't a similar clause or operator and you'd instead have to adopt some workaround with operators such as

<>

or

!=

(eg.

SELECT ... FROM ... WHERE NAME <>"..."

) Again, this is just my guess. Don't quote me on it. I'd be interested in hearing a reply from someone at Prisma.

It would be equivalent to the existing

NOT: {equals: {}}

syntax so nothing new in terms of functionality, just syntactic sugar.

Ah yeah, didn't think of it in that way.