Allow where clause in subgraph queries to reference another field in type

Do you want to request a feature or report a bug?

Feature

What is the current behavior?

Currently, the where clause in a subgraph query only allows you to pass values to it that are of the type of the field being filtered against.

ex:

query Indexers {
  indexers(where: { stakedTokens: 0 }) {
    id
    stakedTokens
    lockedTokens
  }
}

Where: stakedTokens is of type BigInt and the value passed (0 in the example) must also be a BigInt.

What is the expected behavior?

It would be very helpful if the where clause was able to compare two fields against each other to filter results.

ex:

query Indexers {
  indexers(where: { stakedTokens: {indexer? me? this?}.lockedTokens }) {
    id
    stakedTokens
    lockedTokens
  }
}

Mapping down to sql, this would look (something like):

SELECT id, staked_tokens, locked_tokens FROM indexer WHERE staked_tokens = locked_tokens;

Comienza rastreando cómo se analizan las cláusulas where de los subgrafos de GraphQL y se traducen a SQL; el issue no menciona archivos de implementación ni tests. Define la sintaxis de comparación entre campos e identifica las capas de consulta y de base de datos que necesitarían compatibilidad; después, añade cobertura para comparar stakedTokens con lockedTokens.