Appwrite Query GROUP BY/SUM/COUNT

I am learning appwrite, Can you help me, Its possible to Query Group by and Sum or count

await databases!.listDocuments(
        databaseId: "***************",
        collectionId: "***************",
        queries: [
          Query.equal("uid", uid),
          Query.Sum..
        ],

hi 👋

So, your question is if querying by group or sum or count is allowed in Appwrite?

Also, amazing to hear you learning about Appwrite - how are you finding it so far?

So, grouping by sum or count is not available at the moment - however this is a spot we plan on working on this year.

But a workaround could be writing your own function which stores in a database the sum and count (differently) and then they can run the query methods suitable for them. say for example, we want to check the elements who's count is 5 (means they repeat 5 times in database) - for this we would create a function that stores count and then we can use query.equal on their count parameter - if its 5, we get the return