Hey, I would like to perform the following SQL query:

SELECT DISTINCT name FROM City

I don't think there's a way for me to do this using prisma right now because we don't yet have

count_distinct

, is there a way to implement raw sql queries in resolvers though?

hey, that's possible by directly connecting to the database - we're collecting best practices and ideas to improve this workflow here: https://github.com/graphcool/prisma/issues/2052 please leave an upvote + subscribe to stay informed 🙂