On some DBMSs, like Oracle and BigQuery, DatabaseConnector through SqlRender emulates temp tables
in a schema provided by the user. Ideally, these tables are deleted by the application / R script creating them,
but for various reasons orphan temp tables may remain. This function drops all emulated temp tables created in this
session only.
dropEmulatedTempTables(
connection,
tempEmulationSchema = getOption("sqlRenderTempEmulationSchema")
)Invisibly returns the list of deleted emulated temp tables.
The connection to the database server created using either
connect() or dbConnect().
Some database platforms like Oracle and Impala do not truly support temp tables. To emulate temp tables, provide a schema with write privileges where temp tables can be created.