Hi. Does prisma support conditional clauses in a

where

block, similar to laravel's

when()

function. https://laravel.com/docs/8.x/queries#conditional-clauses

Hey Shmuel 👋, Unfortunately prisma doesn’t support

when

clauses inside

where

block. You would need to create a where clause before passing it in query. Something like this

if(title) {
    where = {
      title: { contains: 'prisma' }
    }
  }

  if(description) {
    where ={
      description: { contains: 'prisma' }
    }
  }

  const result = await prisma.post.findMany(where)

Can you please create a new GitHub Issue explaining your exact use case?

Thank you. Your example is pretty much my case.