SNOW-925456: session.write_pandas() behavior inconsistent with underlying snowflake.connector.pandas_tools.write_pandas()

[sfc-gh-madkins]

Please answer these questions before submitting your issue. Thanks!

1. What version of Python are you using?

3.8

2. What operating system and processor architecture are you using?

   macOS-13.6-arm64-arm-64bit

3. What are the component versions in the environment (pip freeze)?

   Replace with the output of python -m pip freeze

4. What did you do?

In https://github.com/snowflakedb/snowpark-python/blob/main/src/snowflake/snowpark/session.py, we

from snowflake.connector.pandas_tools import write_pandas

which is a much better/more robust version that does schema inference ... and we call out its use as well in def create_dataframe

When data is a pandas DataFrame, snowflake.connector.pandas_tools.write_pandas is called ...

but there also exists a def write_pandas that overrides the import and is missing some of the things in the other one

5. What did you expect to see?

   leverage snowflake.connector.pandas_tools.write_pandas