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).
Added a new setting json_type_escape_dots_in_keys to escape dots in JSON keys during JSON type parsing.

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 the json_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.