SQLite Forum

Proposed JSON enhancements.
Login
> they do not aid readability of the SQL IMHO

I've never used the operators in MySQL or PG.  I've only read about them.

My guess that the new operators would be helpful comes with my experience
working on Fossil.  The Fossil repository does not use a lot of JSON, but it
does use some.  (It might have use more if JSON where easier to work with.)
Here is a typical Fossil query that involves JSON (taken from
[here](https://fossil-scm.org/home/info/9dac69b7e238bff22fb4b3?ln=88-91))

> ~~~
     SELECT json_extract(value,'$.base'),
            json_extract(value,'$.hash'),
            json_extract(value,'$.wiki')
       FROM config WHERE name=lower($name)
~~~

To me, this seems easier to write and understand as follows:

> ~~~
     SELECT value->'base', value->'hash', value->'wiki'
       FROM config WHERE name=lower($name)
~~~

Do you disagree?