[WIP] ENH: add Pyarrow csv engine
- [x] closes #23697
- [x] tests added / passed
- [x] passes `black pandas`
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [x] whatsnew entry

Picking up #31817. 

I'm putting this up to use CI for debugging. There are a bunch of comments in #31817 that I haven't addressed yet (working on them) - but I'll take feedback at any time
CI green. @arw2019 Thanks for picking up where I left off. Can you go and rerun the benchmarks to ensure that no performance regressions occurred in the refactor, when this is ready? (Note: speedup should be based on number of cores).

Regarding the other comments, I think it'll be easier to xfail tests if we put all the error checking tests into one file, since those are the ones mostly causing the failures I think. This pull request is stale because it has been open for thirty days with no activity. Please update or respond to this comment if you're still interested in working on this. @arw2019 i think the precursors were all merged, would be nice to get this in. ok - will rebase (sometime in the next few days - it's a little bit of work now) and ping when ready  This pull request is stale because it has been open for thirty days with no activity. Please update or respond to this comment if you're still interested in working on this. Just a heads up that I'm going to try to revive this PR sometime soon-ish.  > Just a heads up that I'm going to try to revive this PR sometime soon-ish.

OK. closing this one as stale. Working on this rn, currently rebasing. Will open new PR.