temporary tables should belong to one database

[lust4life]

in Flink case:

reconstruct the yaml file to make temporary tables belong to one database, as we will register the tables before the user's SQL script, so these temporary tables would be under default_catalog.default_database which might not be convenient for later usage in user's SQL script.

Making it belong to one database will give the user ability to choose how to use it, they can put it under some catalog.database, then use that database or catalog in their ETL file, then have a more convenient reference there.