Is this kind of query possible inside of Prisma without having to run a raw query?
Copy code
SELECT *
FROM guildStats
WHERE (guildId, TIMESTAMP) IN (SELECT guildId, MAX(TIMESTAMP)
FROM guildStats
GROUP BY guildId)
a
Austin
10/19/2021, 12:55 PM
Hey @Sam! Currently, this is not possible without using a raw query. Would you mind filing a feature request if you would like to see this functionality added?