You can create and use temporary (temp) tables in Teiid. Temporary tables are created dynamically, but are treated as any other physical table.