electric-sql
Support json/jsonb operators in where clauses
Currently json/jsonb operators such as ->> are not supported in where clauses, and common operators such as = are not supported on json/jsonb columns or values.
This has been requested by Edward at Herd Labs
This would be very useful to me as well. I'm writing a library to handle offline writes with conflict resolution for electric and I store hybrid logical clocks in jsonb columns. I will likely want to use these in my where clauses.
This is also very important to us. We use nested query quiet a lot, so it would be very useful if some or all of the json queries are supported.
For us the most used are:
->
->>
#>
@>
checking using "any" etc.
https://www.postgresql.org/docs/current/functions-json.html
