We are trying to improve the type hinting for those two functions in pandas-stubs repo. Currently the note in both those functions mentions that we should specify 3 out of 4 arguments among start, end ...

Long ago we made a decision that datetime64 arrays (and Timestamp) were not comparable to date objects, matching the stdlib behavior. We should have that behavior for pyarrow dtypes too.