Developers often create temporary tables to serve a specific purpose in their data loads.
Languages such as Oracle PL/SQL support the creation of temporary tables, so how about extending the scripting language to allow a construct like
Table A :TEMP //or some equivalent syntax structure
The table would be automatically dropped at the end of script execution in the same way mapping tables are. This would remove the need for people to remember to do manual cleanup.
which would automatically drop the (temp) table after its first and next usage. Clean and efficient ?