[Python] Remove `use_legacy_dataset` from code base

[raulcd]

Describe the enhancement requested

We have been warning for a while about legacy dataset being deprecated since Arrow 15.0.0.
Should we remove the warnings and deprecate the use_legacy_dataset keyword arguments?

Legacy dataset was removed here (from what I can find):

• [Python] Remove the legacy ParquetDataset custom python-based implementation #31303

I haven't been able to find an issue to remove that, that's why I am opening it.

Component(s)

Python

[raulcd]

@jorisvandenbossche @AlenkaF is this something we might potentially want to do now? I might be able to try and find some time to do it.

[raulcd]

cc @pitrou

[AlenkaF]

I do not think we created an issue for that looking at the discussion around the use_legacy_dataset keyword arguments under this part of the review: #39112 (review)

so thanks for opening one!
I think we could do this now, it has been a year since the keyword has been deprecated.

[AlenkaF]

Issue resolved by pull request 45742
#45742