SQLite Forum

Proposed JSON enhancements.
Login
I have to admit I've never been a big fan of PostgreSQL's -> and ->> JSON operator design - I find them hard to remember, so I usually it to use the function equivalents instead. That's a matter of personal preference though.

PostgreSQL 14 introduced new syntax which, as a Python and JavaScript programmer, I **really** like. It's described in <https://blog.crunchydata.com/blog/better-json-in-postgres-with-postgresql-14> which gives the following example:

```
SELECT *
FROM shirts 
WHERE details['attributes']['color'] = '"neon yellow"'
  AND details['attributes']['size'] = '"medium"'
```
I would be thrilled to see that syntax added to SQLite!