The most practical and ideal way of creating report with appwrite for complex queries

is there way to write sql queries with appwrite,

TL;DR

The user is asking if it is possible to write SQL queries with Appwrite for complex report creation. They mention the need to count data for various indicators and worry about the performance and speed of the queries. The suggestion given is to keep a running count in a collection rather than calculating it every time. However, if the manager asks for new indicators that weren't previously counted, they will need to use the query API. The user also asks for recommendations on creating reports for monitoring dashboards. Appwrite is recommended for retrieving data through APIs, but if self-hosting, it is possible to connect to the underlying database. The user asks if

Appwrite is an abstraction on top of the underlying database and we recommend retrieving data via the provided APIs.

That said, if you're self hosting, you control the database, so you can connect to it if you'd like

Could you give me some recommendation. let say we are having 10M record of Clients, Meetup, Enrollment tables. I want to count # of clients, # of followup client, # of clients who is male, female, having specific illness for example. what i think, it will be queries alot, the peformance something and speed of responding.

we are showing as a report for dashboard for monitoring.

I would recommend keeping a running count of the data in a collection rather than trying to calculate it every time

like plus, minus every transaction.

@Steven however, this is just few indicators, in case there are hundreds of indicator to count data like this. then, I need to keep count every thing ? lets say, I could not think of . then the manager asks for another 100 indicators which is not kept the count in the collection. then, I will need to count by the query api anyway, any ideas?