Firebird doesn't support renaming tables.
This prevents me from creating a table using AS SELECT... with the Trino query executor, since it creates a temporary table and then tries to rename it.
However, it is possible to create a table using CREATE TABLE ... (LIKE...) followed by INSERT INTO... SELECT..., and in this case, Trino apparently doesn't use a temporary table and doesn't rename it.
If this is indeed true, then instead of modifying the tests so that they can correctly create the test tables, it might be more sensible to modify the way Trino creates the tables based on the connector's support for table renaming?