Not affiliated with Clickhouse, but fwiw they've been working on this for a while (I recall coming across it like +2 years ago in an old Altinity blog post):

https://clickhouse.com/docs/en/integrations/s3/s3-merge-tree...