Teiid supports creating temporary (temp) tables. Temporary tables are created dynamically, but are treated as any other physical table.