SQLite Forum

Handling of json keys containing double quotes

Handling of json keys containing double quotes

(1.1) Originally by anonymous with edits by Richard Hipp (drh) on 2021-08-10 13:34:33 from 1.0 [source]

Hi, I was using SQLite JSON extension with data that has special characters as part of keys (Could be '*','.',' " ' etc). One of the limitations I saw was the handling of double quotes in JSON key when performing path traversal. The issue stems from the fact that SQLite parser doesn't allow escaping of double quotes in the JSON parser. When encountering a dot`, if the next character is a double quote, the parser reads up to the next double quote and uses the enclosed text as the name. Otherwise, it reads up to the next . or [ (Or end of string)

SO post with some more details: https://stackoverflow.com/questions/67993982/sqlite-with-special-character-in-the-json-path

Is there any plan to allow for escaped character handling in this path? Reading the code, I couldn't identify any workarounds we could do.