Renaming OR queries to ANY

[RobertCraigie]

I've received feedback that suggested using ANY instead of OR to structure queries. This means that this query:

posts = await client.post.find_many(
    where={
        'OR': [
            {'title': {'contains': 'prisma'}},
            {'content': {'contains': 'prisma'}},
        ]
    }
)

Would become:

posts = await client.post.find_many(
    where={
        'ANY': [
            {'title': {'contains': 'prisma'}},
            {'content': {'contains': 'prisma'}},
        ]
    }
)

This can make it more clear what the query is actually doing.

It should be noted that this change would have to be completed over a single version bump (0.6.6 -> 0.7.0) due to a mypy limitation.

[TheOnlyWayUp]

ANY imo is more descriptive compared to OR :)

[dv1x3r]

Original prisma library uses OR. I also think that OR is a good option to keep. And and Or are just standard logic operators in every system, and should not be separated.

AND 🤝 OR

https://www.prisma.io/docs/concepts/components/prisma-client/filtering-and-sorting