SNOW-981562: add way to respect user defined schema before inferring schema

[sfc-gh-aalam]

Please answer these questions before submitting your pull requests. Thanks!

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

   Fixes #SNOW-981562

2. Fill out the following pre-review checklist:

   • [x] 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.

   This PR allows users to specify schema for session.crate_dataframe from pandas dataframes. We follow a best effort way to create dataframe using specified schema but fall back to infer-schema if we fail. This is done so we do not introduce a breaking change.