I've used Polars before and can only recommend it.
It's like you get a really good 'query planner' like a DB would give you, but for your notebooks/scripts/etc. Much better than pandas imo.
Why use Polars over just postgresql or sqlite?
Why use Polars over just postgresql or sqlite?