what is the best way to work with csvs?

Have you tried this? https://docs.llamaindex.ai/en/stable/examples/pipeline/query_pipeline_pandas.html#download-data

Yes, that sucks.

it can't even output simple filtering of columns, it doesnt use () in multiple conditions.

I can fix it with the prompt to always output correct logical expressipons but that seems to me a bad way how to do it.