At the moment pydbtools has a create_temp_table method. It would be useful to allow users to do this via an SQL file.
CREATE TEMPORARY TABLE <table name> AS (
<normal SQL query>
)
Would then trigger:
pydb.create_temp_table(sql="<normal SQL query>", table_name = "<table name>")