Allow inserting into remote and data lake

Why it matters

This feature addresses the limitation where insertions were blocked under the disable_insertion_and_mutation setting, which enforces read-only mode for warehouses in ClickHouse Cloud. By enabling inserts into remote and data lake tables despite this setting, it allows more flexible data ingestion scenarios in controlled environments.

How to use it

Set the disable_insertion_and_mutation setting to true to enable read-only mode, then inserts into remote and data lake tables will still be allowed without error, enabling controlled data modifications in these specific table types.