Use ruff to enforce import alias
I replaced the hook `use-pd_array-in-core` with `ruff`'s [`unconventional-import-alias`](https://docs.astral.sh/ruff/rules/unconventional-import-alias/)

The `pre-commit` job will fail to show that the check works. It will pass after I enable `exclude: ^pandas/core/api\.py$`.

If this change is accepted, I can continue with removing the old hook.

As far as I can understand, a major difference is that `scripts/use_pd_array_in_core.py` tries to detect all variants of `pd.<insert anything here>.array` while we must explicitly pass the full path for `ruff` (there's only `pandas.core.construction.array`). 
Looks pretty good. Could you address the pre-commit failure? @mroeschke I fixed the config and removed the old hook. `pre-commit` passes now. The failed pipelines seem unrelated to this PR. Thanks @tqa236 