Here's clickhouse's SQL support: https://clickhouse.com/docs/en/sql-reference/
Compare this to DuckDB's (on the sidebar): https://duckdb.org/docs/sql/introduction
DuckDB's SQL coverage is much more complete and matches my experience with full blown databases like Postgres and Redshift.
As well, performance-wise DuckDB is currently still somewhat faster than clickhouse-local [1] but I would say this is a secondary consideration -- as long as either is "fast enough for your purposes" this shouldn't be an issue -- and clickhouse is plenty fast.
The primary consideration for me would be the SQL support. That said, if you don't use any complex SQL, clickhouse-local seems like it would be a worthy contender.
[1] https://benchmark.clickhouse.com/#eyJzeXN0ZW0iOnsiQXRoZW5hIC...