SQLite Forum

Proposed JSON enhancements.
Login
IMHO the -> and ->> operators should require the left-hand operand to have correct type and subtype

so that ```
        select json('{"a":123}')->'a';
``` should work,

but each of ```
        select '{"a":123}'->'a';
        select cast('{"a":123}' as blob)->'a';
        select 1->'a';
``` should throw an error