I face similar problem. I used something like below as an alternative as Prisma does not support using EXCEPT directly.

const result = await prisma.$queryRawSELECT * FROM TABLE_A EXCEPT SELECT * FROM TABLE_B; console.log(result);