For ClickHouse speed and performance is #1 priority, so it beats most of the other databases. So as an in-house solution, ClickHouse most probably would be the

For ClickHouse speed and performance is #1 priority, so it beats most of the other databases. So as an in-house solution, ClickHouse most probably would be the fastest option (if your use case suits OLAP requirements). For clouds / PaaS - it's hard to compare directly. Do you know how many servers will process your BigQuery request? AFAIK usually BigQuery shows a bit higher performance than single mid-level ClickHouse server (but you can also have a cluster of ClickHouse servers).