I am trying to do some more complex query like this using prisma.io:
prisma.someModel.findMany({
where: {
AND: [
{
OR: [
{ firstName: { contains: 'John' } },
{ lastName: { contains: 'John' } }
]
},
{
OR: [
{ firstName: { contains: 'Doe' } },
{ lastName: { contains: 'Doe' } }
]
}
]
}
})
Is there a way to do something like this?