SNOW-687932: Using Temporary tables after write_pandas

[holeinone986]

What is the current behavior?

When using write_pandas the cursor is closed afterwards regardless of table type

What is the desired behavior?

When table type is temp or temporary cursor should be left open so the temp table can be used after table creation

How would this improve snowflake-connector-python?

Would allow for use of temp tables in other sql queries such as using the temp table in a merge query

References, Other Background

[holeinone986]

Or ability to pass the open cursor to a variable