Clickhouse or DuckDB are databases I would look at that support this use case pretty much "out of the box"
E.g. https://benchmark.clickhouse.com has some query times for a 100 million row dataset.
E.g. https://benchmark.clickhouse.com has some query times for a 100 million row dataset.
I hope it receives more love.