Improve file encryption/compression handling

[sfc-gh-dszmolka]

What is the current behaviour?

For operations like (including, but not exclusive to) PUT and GET, when reading from file, the temporary file is needed to verify, even if we may perform operation in memory.

While due to recent improvements the temp directory is now customizable, there still might be improvements considered.

What is the desired behavior?

Reviewing and improving the scenarios where we use temp files today. For example, use streams instead, without requiring temp files.

How would this improve gosnowflake?

Would improve usability in environments where the local filesystem is read-only.

References, Other Background

Started as a child issue of #832 to track the second request.

What is your Snowflake account identifier, if any?

N/A

[sfc-gh-dszmolka]

Q3 is fully booked for now, so we'll consider this for later quarters.