[Python][Parquet] Parquet logical types should be mapped to corresponding extension types at read time

[rok]

Describe the enhancement requested

In c++ implementation we have ArrowReaderProperties.set_arrow_extensions_enabled to enable this behavior.
See comment and documentation.

Component(s)

Python

[jorisvandenbossche]

In addition to exposing it as an option, I am also wondering if we shouldn't make this enabled by default

[NellyWhads]

Has there been any further movement on this?

[paleolimbot]

Agreed that I think this is a good idea (to enable this by default!) #45866 exposed arrow_extensions_enabled to Python so that it can be disabled if it causes an issue.

[paleolimbot]

Are there any objections to implementing this? (I'm happy to make the change!)

[rok]

@paleolimbot please go ahead, I go distracted with other work, I'm happy to review.

[AlenkaF]

Issue resolved by pull request 46772
#46772