Support Remote Schema Relationships to Attributes within JSON Fields

[tiafouroohi]

Component

Remote Schema Relationships

Is your proposal related to a problem?

Have a Remote Schema to another GraphQL service, and among the fields on one or more types, there is a JSON field with deeply-nested attributes. Also have Remote Relationships between that Remote schema and other fields in the GraphQL API from database tables. Would like to make the Remote Relationship relate to a scalar field from a database table one one side, to a deeply-nested attribute from the Remote Schema JSON field on the other side. Given how Remote Relationships work, this is not possible. The type of relationship depends on the type of the scalar fields involved. In the case of JSON or JSONB data, it doesn't really support anything like JSON-Path, so that you could related a field from one schema, to a deeply nested attribute in a JSON field in another schema.

Describe the solution you'd like

Support Remote Relationships to attributes within JSON fields.

Describe alternatives you've considered

N/A