SQLite Forum

Proposed JSON enhancements.
Login
I use the nonstandard <code>\`</code>...<code>\`</code> syntax, and some others might use the nonstandard `[`...`]` syntax. Often the SQL codes are embedded in C codes, and for this purpose, it is helpful, instead of using the quotation marks (avoiding needing the additional escaping) (but when the SQL codes are in external files, the quotations marks can be in use).

I think the JSON specific syntax is not needed for core SQL. In the case of `->` it is not a conflict and can be overridden anyways, it is not a problem; however, using the square brackets for JSON can be problem due to already being in use for something else.