v.24.10Experimental Feature
Allow JSON column to be serialized/deserialized as String in Native format
Allow to serialize/deserializeJSONcolumn as single String column in the Native format. For output use settingoutput_format_native_write_json_as_string. For input, use serialization version1before the column data. #70312 (Pavel Kruglov).
Why it matters
This feature addresses the need to handleJSON columns more flexibly by enabling them to be serialized and deserialized as plain strings within the Native format. It simplifies data interchange scenarios where JSON data is better handled as string data, improving compatibility and usability.How to use it
To serializeJSON columns as strings in output, enable the setting output_format_native_write_json_as_string. For deserialization (input), use serialization version 1 before the column data to interpret the JSON column as a string.