Hey everyone. I am using postgres json and I was wondering if I can select specific fields from a json field using prisma. So, for instance this query

*select* p."json"->>'email' *as* email *from* "Party" p

in prisma. Something like:

db.party.findMany({ select: { json->>'email': true } })

?

Hey Martijn, welcome to our Slack 😄 👋

I was wondering if I can select specific fields from a json field using prisma

Unfortunately, this is not possible at the moment but we do have an open feature request for it already: https://github.com/prisma/prisma/issues/2431 It would be great if you could leave a 👍 and a comment on the request with your specific use case for that feature, this helps our Product and Engineering teams evaluate and plan what features to put on the roadmap 🙂

You guys are way ahead of me! 😄 I’ll leave a comment on the issue.