Support Schema Inference for Insert Select with Input Table Function

Why it matters

This feature addresses the problem of schema inference when performing INSERT SELECT operations from table functions that support schema inference, such as input. Instead of inferring the schema based on the input data, which may be unreliable or ambiguous, the schema is directly obtained from the target insertion table. This ensures consistency and correctness in schema determination during insertion, improving user experience and reducing errors.

How to use it

When performing an INSERT SELECT operation from a table function like input, the schema will automatically be inferred from the destination table's schema. No additional configuration is required from the user to enable this behavior.