SQLite Forum

json_extract behavior with escaped-double-quote keys
Login
> select json_extract('{ "a": 1, "\"b\"": 2 }', '$."\"b\""');

This variation works for m:

```
SQLite version 3.35.0 2021-03-09 21:20:12
Enter ".help" for usage hints.
sqlite> select json_extract('{ "a": 1, "\u0022b\u0022": 2 }', '$."\u0022b\u0022"');
2
```

Where `\u0022` ==> `"`.

It ain't pretty, but neither is doubling up on double quotes ;).