Prisma

I'm trying to have a find many distinct with count is that possible?

Hey there!

Could you provide more details on exactly what you’re trying to achieve? That will help me come up with an accurate answer :slightly_smiling_face:.

Watch Table with Aid Bid
Profile Table with id, [other profile fields]

I want to get
-List of Bids distinct
-Count of Aids based on the distinct (grouping)
-Profile fields match to Profile.id = Watch.Bid

There isn’t a single Prisma query that would fulfill all of those conditions, so I think you will have to stick with `$queryRaw` for now.

Feel free to open a <https://github.com/prisma/prisma/issues/new?assignees=&amp;labels=&amp;template=feature_request.md&amp;title=|feature request> if you would like to see Prisma handle this kind of query in the future.

Did raw. I think i saw feature request for that but will check again.