If you have thousands of clients writing to the database individual rows, one per request, and thousands of clients making queries (some of them are complex, some are not). Does ClickHouse even get used in this scenario?
e.g. https://clickhouse.com/docs/en/interfaces/third-party/proxy/