hasura / hasura/graphql-engine
Support for more JSONB operators for Postgres
- Dominant language
- TypeScript
- Stars
- 32.1k
- Forks
- 3k
- PR merge metrics
- PR metrics pending
Description
### Description
Currently, the [documentation](https://hasura.io/docs/latest/queries/postgres/filters/jsonb-operators/) for JSONB column operators has support for only `_contains`, `_contained_in`, `_has_key`, `_has_keys_any` and `_has_keys_all`.
However, in PostgreSQL, we can execute queries using operators such as >, <, =, among others, as illustrated in the example below:
```sql
select * from service_item_instances where (custom_data ->> 'screen_size')::int > 30;
```
The documented operators might not suffice for operations like >, <, =, and similar comparisons.
Contributor guide
Research direction
Start with the JSONB column operators documentation linked in the issue and reproduce the PostgreSQL comparison example. Then trace how the existing documented operators are exposed through filtering; done means the requested comparison operators are supported and documented with coverage for the relevant behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100