I think you can query and join polars dataframes if you call to_arrow() on them too.

You dont need to do that afaik. You just query them.

well, duckdb works very well with pandas, too