[CI] Modernize AppVeyor build

[pitrou]

Describe the enhancement requested

The AppVeyor build is using a bunch of outdated idioms and workarounds, such as calling setup.py directly to install PyArrow.

Component(s)

Continuous Integration, Python