v.25.12Improvement

Support storage settings

Support storage settings inside functions in INSERT INTO FUNCTION, similar to how they are already supported for SELECT. Closes #89386. #91707 (Kseniia Sumarokova).
Added support for specifying storage settings inside functions in INSERT INTO FUNCTION statements, similar to the existing support in SELECT queries.

Why it matters

This feature allows users to define storage-related settings directly within INSERT INTO FUNCTION statements, providing greater flexibility and control over data insertion behavior when using table functions. It helps address the limitation where storage settings could previously only be specified during SELECT operations, improving usability and consistency across query types.

How to use it

Users can specify storage settings inside a INSERT INTO FUNCTION query by including the desired settings directly within the statement, analogous to how settings are passed in SELECT queries involving table functions. This enables customized behavior for data insertion into table functions without needing external configuration.