Tracking: `pyarrow-stubs` upstream fixes

[dangotbanned]

Following #2007, there were a lot of things that still needed addressing upstream.

The end-goal will be removing/greatly reducing the need for the Incomplete marker and excessive use of typing.cast(...) - to get things working

PRs

I expect this list may grow longer - depends on how many things are solved by (zen-xu/pyarrow-stubs#181)

• fix: Preserve generic in ChunkedArray.type zen-xu/pyarrow-stubs#177
• fix: Widen Array to Array | ChunkedArray zen-xu/pyarrow-stubs#181
• fix: Add placeholder annotations to pc.if_else zen-xu/pyarrow-stubs#182
• fix: Avoid chunked_array overlapping overloads zen-xu/pyarrow-stubs#183
• fix: resolve some pa.compute overlaps zen-xu/pyarrow-stubs#184
• fix: add pc.fill_null zen-xu/pyarrow-stubs#185
• fix: Include Array in chunked_array overload zen-xu/pyarrow-stubs#190
• fix: Add missing pc.equal overload zen-xu/pyarrow-stubs#196
• feat: Fully spec TableGroupBy.aggregate zen-xu/pyarrow-stubs#197
• fix: Allow Iterable[Table] in concat_tables zen-xu/pyarrow-stubs#203
• fix: Allow ChunkedArray[BooleanScalar] in pc.invert zen-xu/pyarrow-stubs#204
• fix: Add missing return type to ChunkedArray.filter zen-xu/pyarrow-stubs#205
• fix: Add relaxed final overload to logical functions zen-xu/pyarrow-stubs#206
• fix: Resolve Scalar.as_py warnings for DictionaryType zen-xu/pyarrow-stubs#207
• fix: Resolve pa.scalar overload overlaps zen-xu/pyarrow-stubs#208
• fix: Resolve all array.pyi errors zen-xu/pyarrow-stubs#209
• fix: Allow ChunkedArray in Table.set_column zen-xu/pyarrow-stubs#211
• feat: Convert types.is_* into TypeIs guards zen-xu/pyarrow-stubs#215
• fix: Add default to pc.sort_indices zen-xu/pyarrow-stubs#216
• fix: Match runtime behavior of (Table|RecordBatch).select zen-xu/pyarrow-stubs#221
• fix: Add missing DictionaryArray methods/properties zen-xu/pyarrow-stubs#226

Issues

• Type Stubs Maintenance/Tooling zen-xu/pyarrow-stubs#186
• [Python] Type stubs apache/arrow#30426
• A new home for pyarrow-stubs? apache/arrow#45919

Releases

• https://github.com/zen-xu/pyarrow-stubs/releases/tag/17.18
  • Partially updated in (0237f7a)
  • Fully updated in chore: Clean up _arrow #2275
• https://github.com/zen-xu/pyarrow-stubs/releases/tag/19.1
  • chore: bump pyarrow-stubs==19.1 #2350
• https://github.com/zen-xu/pyarrow-stubs/releases/tag/19.2
  • chore: bump pyarrow-stubs==19.2 #2458
• https://github.com/zen-xu/pyarrow-stubs/releases/tag/19.3

apache/arrow

• GH-32609: [Python] Add type annotations to PyArrow apache/arrow#47609