ENH: Give DataFrame.to_sql() the option to create temporary tables. #41335
Description
Is your feature request related to a problem?
I wish I could create temporary tables using the DataFrame.to_sql() method.
Describe the solution you'd like
Add a new boolean kwarg to the to_sql() method that if set to True, will cause the table to be created as a temporary table.
API breaking implications
One new argument, defaulting to False - shouldn't change any normalbehavior.