@Markey Boi 👋 I don’t think this would be possible with Prisma. There’s a lot of raw query stuff like

EXISTS

and custom fields like difference of

COUNT

, so a raw query would be a better fit in this case.

Ok, if we ignore the exists stuff for a minute is there a non-raw query way to findMany of an entity and include the count of 2 things it's related to (in my case I want to findMany posts with the count of its upvotes and downvotes)?

Does your schema look something like this?

model Post {
  id Int @id
  upvotes Int @default(0)
  downvotes Int @default(0)
}

No, I have upvotes and downvotes as separate entities. I discovered the _count key for include so I think I figured out a workable solution which looks like

const posts = await this.prisma.post.findMany({
	include: {
		_count: {
			select: {
				upvote: true,
				downvote: true
			}
		},
		upvote: {
			where: {
				accountId: accountId
			}
		},
		downvote: {
			where: {
				accountId: accountId
			}
		}
	}
});

Prisma always escapes strings by default.