Does someone know if it is possible to make a

where

clause that only returns rows where a specific column is

null

?

Probably best to read through this to understand how prisma treats null/undefined https://www.prisma.io/docs/concepts/components/prisma-client/null-and-undefinedv

Thanks! Just validated that null is a value using

equals: null

and it works!

const episodes = await db.episode.findMany({
    where: { showId, scheduledDate: { equals: null } },
    take: 30,
  })