v.25.12Improvement
Support storage settings
Support storage settings inside functions inINSERT INTO FUNCTION, similar to how they are already supported forSELECT. Closes #89386. #91707 (Kseniia Sumarokova).
Why it matters
This feature allows users to define storage-related settings directly withinINSERT 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 aINSERT 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.