SQLite Forum

The [json_extract()][1] function should return an unquoted string when the
PATH argument refers to a string value.

[1]: https://www.sqlite.org/json1.html#the_json_extract_function