Prisma

Hey all.  I have the following query, is it possible to do with Prisma?

```select id, name, "categoryId", a."createdAt" from forum_post fp 
inner join (select "postId", max("createdAt") as "createdAt" from forum_post_reply group by "postId") a on a."postId" = fp.id 
order by a."createdAt" desc;```
Thanks

Hey Paul :wave:

You should be directly able to invoke this query by using <https://www.prisma.io/docs/concepts/components/prisma-client/raw-database-access|Raw Query>.
As per your query, you should be able to <https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#select|select> specific fields, use <https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#include|include> to get relation fields and use <https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#groupby|groupBy> and <https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#orderby|orderBy>

Hi <@U024DS62DRC>.  Yes I'm doing it right now with Raw Query.

Unfortunately I was only able to go so far with Prisma natively as I wasn't able to order (the main query) by the contents of the joined subquery.  Hence the question.