How do you chose between ClickHouse and DuckDB ? It feels like they solve the same problem

Different beasts, but if by any chance you love ClickHouse already and just want to run OLAP queries in-process, there's chdb: https://github.com/chdb-io/chdb