ENH: expose `to_pandas_kwargs` in `read_parquet` with pyarrow backend
- [x] closes #49236, #56842
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [x] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

@jorisvandenbossche would you be able to review? Tagging you since you mentioned this in #56842. > Would be better if also add `to_pandas_kwargs` to `read_parquet` explicitly.

I wasn't sure if I should do this since it is an engine specific option. Happy to add it though. Looking forward to upgrading to this fix. Due to this issue, I am currently using pickles, which is not ideal. This pull request is stale because it has been open for thirty days with no activity. Please [update](https://pandas.pydata.org/pandas-docs/stable/development/contributing.html#updating-your-pull-request) and respond to this comment if you're still interested in working on this. Thanks for the pull request, but it appears to have gone stale. If interested in continuing, please merge in the main branch, address any review comments and/or failing tests, and we can reopen. (I see that in https://github.com/pandas-dev/pandas/pull/57044, we had some discussion if we actually want this .. Will move that part of the discussion to the issue) @jorisvandenbossche I think I've addressed your comments and resolved merge conflicts. Thanks @kleinhenz!