DuckDB is one of my favourite projects of late.

Some is a little rough around the edges but it has extremely quickly replaced much more complicated setups for me. It's fast and very simple and pairs beautifully with having a bunch of data just in parquet files.

https://duckdb.org/