SNOW-1620436 Improved to_datetime to handle all local input cases and improved time series notebook tests

[sfc-gh-azhan]

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

   Fixes SNOW-1620436

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.

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

   Please write a short description of how your code change solves the related issue.

This pull request includes several changes to improve the handling of datetime conversions and related tests in the Snowpark Modin integration. The most important changes include enhancements to the to_datetime function, updates to internal utility messages, and adjustments to test cases for better accuracy and performance.

Improvements to to_datetime function:

• Improved pd.to_datetime to handle all local input cases. (CHANGELOG.md)
• Updated to_datetime to handle non-Modin objects using pandas.to_datetime and to return appropriate Modin objects. (src/snowflake/snowpark/modin/pandas/general.py) [1] [2]
• Refined the handling of timezone-naive and timezone-aware inputs in to_datetime. (src/snowflake/snowpark/modin/pandas/general.py) [1] [2]

Updates to internal utilities:

• Introduced AUTO_FORMAT_WARNING_MSG for consistent warning messages about Snowflake's automatic format detection. (src/snowflake/snowpark/modin/plugin/_internal/timestamp_utils.py)
• Updated warning messages to reflect potential mismatches with pandas more clearly. (src/snowflake/snowpark/modin/plugin/utils/warning_message.py)

Adjustments to test cases:

• Modified test cases to use pd.Index for datetime inputs to ensure consistency and accuracy in results. (tests/integ/modin/tools/test_to_datetime.py) [1] [2] [3]
• Adjusted SQL query count expectations in tests to reflect the improved performance of to_datetime. (tests/integ/modin/tools/test_to_datetime.py) [1] [2] [3]

These changes enhance the robustness and performance of datetime handling in the Snowpark Modin integration, ensuring better alignment with pandas behavior and more accurate test coverage.

[sfc-gh-azhan]

match with what we do today for DatetimeIndex and timedelta.

[sfc-gh-nkrishna]

One minor nit, but LGTM!

[sfc-gh-helmeleegy]

Are we sure we don't want to break up this PR?

[sfc-gh-azhan]

Are we sure we don't want to break up this PR?

It's only two changes on src:

1. use pandas to_datetime for local inputs
2. warning message change

Others are just test updated based on the above two.

I did include most of tests from the pandas time series doc in our notebook in this PR. But should be fine if something can be improved there, we can use followup PRs

[sfc-gh-helmeleegy]

Are we sure we don't want to break up this PR?

It's only two changes on src:

1. use pandas to_datetime for local inputs
2. warning message change

Others are just test updated based on the above two.

I did include most of tests from the pandas time series doc in our notebook in this PR. But should be fine if something can be improved there, we can use followup PRs

This makes sense.