v.23.1Improvement

Enable JSON Input Format for Reading Nested Objects by Default

Enable input_format_json_read_objects_as_strings by default to be able to read nested JSON objects while JSON Object type is experimental. #44657 (Kruglov Pavel).
Enabled input_format_json_read_objects_as_strings by default to allow reading nested JSON objects, as the JSON Object data type remains experimental.

Why it matters

This feature addresses the challenge of parsing nested JSON data by treating nested objects as strings, providing a stable method to ingest complex JSON structures without relying on the experimental JSON Object type. It improves robustness and usability when working with nested JSON inputs.

How to use it

The setting input_format_json_read_objects_as_strings is now enabled by default. Users can simply import nested JSON data without additional configuration. To override this behavior, set input_format_json_read_objects_as_strings to 0 explicitly in the session or server configuration.