SQLite Forum

Proposed JSON enhancements.
Login
The "`[]`" operator is not available to SQLite.  Microsoft SQL Server uses
square brackets to quote identifiers.  For example, instead of
`"columnname"` they write `[columnname]`.  This is not standard SQL, but
it is *extremely* common among programmers who first learned SQL from
SQL Server.  SQLite provides square-bracket quoting too, for compatibility
with SQL Server, and has for 20 years.  Hence, we cannot use `[]` as an
operator.