Add format_json_object_each_row_column_for_object_name setting for JSONObjectEachRow format

Why it matters

This feature addresses the need to represent object names as column values when using the JSONObjectEachRow format, improving flexibility and compatibility for users working with JSON data structures in ClickHouse. It allows better handling of object names in JSON rows, which facilitates data interchange and processing workflows.

How to use it

Enable the feature by setting format_json_object_each_row_column_for_object_name to 1 or true in your ClickHouse client session or server configuration. This will make ClickHouse write and parse the object name as a column value when using the JSONObjectEachRow format. Example:

SET format_json_object_each_row_column_for_object_name = 1;
SELECT * FROM table FORMAT JSONObjectEachRow;