SNOW-616199: updated _resolve_packages to only query for added packages

[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.

   No existing github issue. Only addressing JIRA SNOW-616199

2. Fill out the following pre-review checklist:

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

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

   • Updated code to only query for packages and versions that are requested in add_packages method.
   • Updated code to check if requested versions are available in Snowflake. Raise error if they are not.
   • Updated code to warn when local version of python package does not match with any supported packages on Snowflake server

[github-actions[bot]]

CLA Assistant Lite bot All contributors have signed the CLA ✍️ ✅

[sfc-gh-aalam]

I have read the CLA Document and I hereby sign the CLA

[sfc-gh-jdu]

Just dump the release notes here

When adding a package using session.add_packages() with a specific version to UDFs or stored procedures, if the version is not supported by Snowflake, an exception will be raised immediately instead of when registering the UDF or stored procedure.