server: support for boolean expressions across relationships to Native Queries

### Is your proposal related to a problem?

This FR is raised with the limitation described here in [10607](https://github.com/hasura/graphql-engine/issues/10607)

Currently, user cannot filter based on nested objects , in this case Native query relationship to a DB table.

### Describe the solution you'd like

Ability to filter through Native query relationship(filter based on nested object, here NQ relationship) for all the databases which support native queries.

Start with the limitation described in issue 10607, then investigate how native query relationships and nested-object filtering are handled across databases that support native queries. Done means boolean expressions can filter through native query relationships for all supported databases.

Written by the indexing model from the issue text.