Periods (.) in JSONpath item names

[James Powell]

Had issue where a client had JSON item “4.5”, which when converted to a path, was “$.something.4.5.item”.

This path failed to point at the item as it was interpreted as item “4”, then “5”, rather than “4.5”.

Note: JSON1 extension of SQLite has same problem.

Idea: support parts of paths as quoted JSON strings:

\$.something.”4.5”.item

Either automatically detect periods in strings and quote just those items (requires detection of quoted item names), or have a “strict mode” that quotes everything ($.”something”.”4.5”.”item”)

‌

[James Powell]

Note: JSON1 in SQLite seems to support quoted item names in JSONpaths (though undocumented).

[James Powell]

Modified “Flatten JSON Object to JSONpath Array” to make item names with periods quoted JSON strings. Unflatten function already supports this.