I haven't tried chDB yet, but I heard about it. Thank you for reminding me of that option.

I use SQL in data pipelines and processing that is going to require interoperability.

But for data exploration, I usually prefer Polars (imo it is easier to work with text, semi-structured data, etc.)