Hi all, is there any way using aggregation function on a computed value? for example:

SELECT AVG(LENGTH(value)) FROM Word

Maybe something similar to

prisma.word.aggregate({
    _avg: { value: { length: true } }
});

Hi @Dor Meiri 👋 We could utilize the

QueryRaw

for this operation. For example:

const result = await prisma.$queryRaw`SELECT  AVG(LENGTH(value)) FROM Word;

Hi @Raphael Etim, thanks for the answer, but this is something I want to generalize, I want to have the possibility having includes and where in the aggregation in various combinations. Doing it with

QueryRaw

can be bit messy. Is there an ORM-ish way of doing it?

I'm investigating this and will get back to you with a response.