SNOW-1359484 Allow write Snowpark pandas DataFrame and Series in sess…

[sfc-gh-azhan]

…ion.write_pandas

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

   Fixes SNOW-1359484

2. Fill out the following pre-review checklist:

   • I am adding a new automated test(s) to verify correctness of my new code
   • I am adding new logging messages
   • I am adding a new telemetry message
   • I am adding new credentials
   • I am adding a new dependency

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

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

Allow user to use session.write_pandas to write Snowpark pandas objects:

• It reuse and does not change the interface of write_pandas
• it reuse to_snowflake to implement the write logic
• copied main tests from test_pandas_to_df.py and use them to test writing Snowpark pandas DataFrame.

[sfc-gh-helmeleegy]

Looks great overall. Just a few minor nits.

[sfc-gh-helmeleegy]

LGTM. Thanks for taking care of this!

[sfc-gh-jrose]

It would be nice to have a test that validates the naming conventions as well to make sure the quote_id code paths are working correctly.

It's also surprising to me that new functionality would not require a CHANGELOG update.

[sfc-gh-azhan]

It would be nice to have a test that validates the naming conventions as well to make sure the quote_id code paths are working correctly.

I have integ tests to cover the case where quote_id is true or false, and the code is basically the same as the existing code:

snowpark-python/src/snowflake/snowpark/session.py

Line 2219 in cc3d289

if quote_identifiers:

It's also surprising to me that new functionality would not require a CHANGELOG update.
The change log is added in pandas_changelog.md. In the next release, we will merge them together so this is not in changelog.md.