Support same operators for JSON as JSONB

### Is your proposal related to a problem?
Kind of

### Describe the solution you'd like
Right now hasura supports [these operators for `JSONB`](https://hasura.io/docs/latest/graphql/core/api-reference/graphql-api/query.html#jsonb-operators). It would be nice to support the same operators for `JSON` type as well

### Describe alternatives you've considered
We could change to column to `JSONB` but would like to have it as `JSON`

### If the feature is approved, would you be willing to submit a PR?
I wish I could but Haskell has a steep learning curve, one day...

Start with the JSONB operators listed in the linked Hasura GraphQL API documentation and trace where those operators are exposed for PostgreSQL types. Compare the existing JSONB behavior with JSON support, and consider the work done when the same operators work for JSON columns without requiring a conversion to JSONB.

Written by the indexing model from the issue text.