Added default_temporary_table_engine setting for temporary tables

Why it matters

To provide users control over the default storage engine used for temporary tables, enabling customization and consistency in temporary table creation without explicitly specifying the engine each time.

How to use it

Set the default_temporary_table_engine parameter in the server configuration or session settings to the desired table engine name. This will make new temporary tables use the specified engine by default.