Prisma: Finding items where two fields have the same value

Question

I would like to find items in a Prisma db where the values for two columns are the same. The use case is to compare the 'created_at' and 'updated_at' fields to find items that have never been updated after their initial creation. In raw SQL I would do something like:

select updated_at,
       cast(sign(sum(case when updated_at = created_at then 
          1 
       else
          0
       end)) as int) as never_modified
  from tab
 group by updated_at

Is it possible to achieve this in Prisma?

Answer 1

you can use the preview feature fieldReference of prisma.

schema.prisma

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["fieldReference"]
}

your code

prisma.project.findMany({
  where: { created_at: prisma.project.fields.updated_at }
})