[Python] Support pandas dtype_backend=pyarrow in to_pandas

### Describe the enhancement requested

As pandas 2.0 start supporting pyarrow as engine and dtype.
If we can support it in [pyarrow.Table.to_pandas()](https://arrow.apache.org/docs/python/generated/pyarrow.Table.html#pyarrow.Table.to_pandas) will be really helpful and efficient.

### Component(s)

Python

Start with the Python pyarrow.Table.to_pandas() entry point mentioned in the issue and review pandas 2.0's dtype_backend documentation. Determine the expected behavior for dtype_backend=pyarrow and identify the relevant conversion tests before changing anything. Done means pandas conversions accept the pyarrow backend and produce correct results.

Written by the indexing model from the issue text.