SNOW-1722641: Add support for Series.between

[sfc-gh-joshi]

1. Which Jira issue is this PR addressing? Make sure that there is an accompanying issue to your PR.

   Fixes SNOW-1722641

2. Fill out the following pre-review checklist:

   • I am adding a new automated test(s) to verify correctness of my new code
     • If this test skips Local Testing mode, I'm requesting review from @snowflakedb/local-testing
   • I am adding new logging messages
   • I am adding a new telemetry message
   • I am adding new credentials
   • I am adding a new dependency
   • If this is a new feature/behavior, I'm adding the Local Testing parity changes.
   • I acknowledge that I have ensured my changes to be thread-safe. Follow the link for more information: Thread-safe Developer Guidelines

3. Please describe how your code solves the related issue.

Implements Series.between. The frontend implementation uses modin's implementation, which passes the modin.pandas.Series object to the native pandas method, which directly uses comparison operators to implement the method.

[sfc-gh-jjiao]

This is just fall back to native pandas, right?

[sfc-gh-joshi]

This is just fall back to native pandas, right?

Yes, but not in a way that causes extra materialization (the native pandas method just uses comparison operators and &, so we can preserve lazy evaluation).

[sfc-gh-helmeleegy]

This is just fall back to native pandas, right?

Yes, but not in a way that causes extra materialization (the native pandas method just uses comparison operators and &, so we can preserve lazy evaluation).

No, native pandas is not being used here. This was just falling back to modin implementation which itself routes to other supported Snowpark pandas methods (comparison operators).

[sfc-gh-joshi]

No, native pandas is not being used here.

The modin frontend implementation (here) actually calls a native pandas method (here), but the native pandas method routes to Snowpark pandas comparison operators.

[sfc-gh-helmeleegy]

Nice work. Thanks, Jonathan!