v.25.8Improvement
Add a setting json_type_escape_dots_in_keys to escape dots
Add a setting json_type_escape_dots_in_keys to escape dots in JSON keys during JSON type parsing. The setting is disabled by default. #84207 (Pavel Kruglov).Why it matters
This feature addresses the problem of interpreting JSON keys that contain dots, which can cause issues during parsing by being misread as nested keys. Escaping dots ensures accurate parsing of JSON data where keys include dots, improving data correctness and usability.How to use it
To enable escaping of dots in JSON keys, set thejson_type_escape_dots_in_keys setting to 1 in your session or query settings. By default, this setting is disabled. Example usage:SET json_type_escape_dots_in_keys = 1;This will activate the escaping behavior during JSON parsing.