Improved JSON type parsing that selects the best matching type when a JSON path contains values of multiple types.
Why it matters
This feature addresses the issue where JSON parsing encounters mixed types within the same JSON path block. By attempting types in a special best-effort order, it enhances type inference accuracy, providing more reliable and consistent parsing results for users working with heterogeneous JSON data.How to use it
This improvement is applied automatically during JSON path parsing and does not require any additional configuration from the user. When querying JSON with mixed types, the parser will internally select the most appropriate type based on the new best-effort order.