SQLite Forum

Proposed JSON enhancements.
Login
ah so in your case the json is in the db and the value to check for is the parameter.

and if the json is not stored in the db?  lets say match targets are stored and the json is the parameter?  

while your use case is the most common, i can see it being used similar to storing glob/re patterns to be used on a parameter.  in that case the targets are schema checked, but not the json.

in your use case you rely on the schema constraint as your wrapper. in the non stored json case the proposal requires the wrapper in the query.  The suggestion for the -> operator (not the -->)  gives us one way to handle that.   another is argument flag.