Allow creating and inserting into temporary tables

Why it matters

This feature provides flexibility by permitting users to work with temporary tables for intermediate data processing without being blocked by the global disable_insertion_and_mutation setting. It enables maintaining restrictions on permanent table modifications while still allowing necessary temporary operations.

How to use it

Ensure the disable_insertion_and_mutation setting is enabled to restrict modifications on permanent tables. You can still create and insert data into temporary tables as usual within your sessions using CREATE TEMPORARY TABLE and INSERT INTO statements.