I've found the solution here https://github.com/prisma/prisma/discussions/8216#discussioncomment-992302

It should be like this instead apparently.

await prisma.product.findMany({
      where: {
        AND: [
          { price: 21.99 },
          { filters: { some: { name: 'ram', value: '8GB' } } },
          { filters: { some: { name: 'storage', value: '256GB' } } },
        ],
      },
})

I'm not sure if I'm missing something. But your prisma query basically already generates same SQL query that you wrote below.

@ManishKarki1997 👋

I have tested this with random data and this works:

await prisma.product.findMany({
      where: {
        AND: [
          { price: 21.99 },
          { filters: { some: { name: 'ram', value: '8GB' } } },
          { filters: { some: { name: 'storage', value: '256GB' } } },
        ],
      },
})

Considering this schema file:

generator client {
  provider        = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model test {
  id        Int      @id @default(autoincrement())
  name      String
  updatedAt DateTime @updatedAt
}

You can nest AND and OR operators like this:

  await prisma.test.findMany({
    where: {
      AND: [
        {
          OR: [
            {
              name: 'test1',
            },
            {
              name: 'test2',
            },
          ],
        },
        {},
      ],
    },
  });

By default all the fields in the where clause are combined with AND operator so you might only need to use the OR operator.

For reference: AND and OR Prisma Documentation.

This is the right solution, the authorship is not mine, the guys helped me find it.

        const product = await this.prismaService.product.findMany({
        where: {
            AND: [
                { price: 21.99 },
                { options: { some: { title: 'invertor', description: '25' } } },
                { options: { some: { title: 'type', description: 'invertor' } } },
                { options: { some: { title: 'WiFi:', description: 'yes' } } },
            ],
        },
        include: { options: true },
    });