Clickhouse is not a good fit here, use S3 select, Athena, even duck db etc.
Why do you think so?
The query performance of ClickHouse will be well above any of the listed engines.
The versatility of the query language and support for data formats are also way ahead.
There's no need for being a good fit when the point experimenting the limits of an idea and shape its future based on the found limitations. There are more parts to this! Also IMHO DuckDB is just mimicking what ClickHouse already does a lot better.