Definitely clickhouse ecosystem. - For querying csv data from command line, I use clickhouse-local. - For querying csv data programmatically using a library,

Definitely clickhouse ecosystem. - For querying csv data from command line, I use clickhouse-local. - For querying csv data programmatically using a library, I use chdb (embedded version of clickhouse) - For querying large amount of csv data programmatically, I offload it to clickhouse cluster which can do processing in distributed fashion. If you are looking from query performance perspective, this blog is useful: https://www.vantage.sh/blog/clickhouse-local-vs-duckdb https://www.vantage.sh/blog/clickhouse-local-vs-duckdb