Query service, add query filter for virtual fields and sortable

[jiqiang90]

Prerequisites

• Are you running the latest version(s)?
• Did you check the debugging guide?
• Did you check the FAQs and Discussions?
• Are you reporting to the correct repository?
• Did you search for an existing issue or pull request?

Description

We want a feature allow user to filter the virtual fields/entity's attributes when query, for example:

we want to sort authors by the amount of books written after a certain year

type Author @entity{
  id:ID!
  books: [Book]! @derivedFrom(field:"author")
}

type Book @entity{
  id:ID!
author: Author!
year: Int!
}

• add filter for connection fields
• make compute column sortable

Details

These details can help to reproduce the environment the issue is occurring

Local Environment: [You can get this information from executing subql version.]
Query Version: [What is the version of the query service?]
Indexer Version: [What is the version of the indexer service?]
Network Details:

• [Network]
• [Block height, a block height where the issue is happening]
• [Dictionary endpoint, if used]

Steps to Reproduce

1. [First Step]
2. [Second Step]
3. [and so on...]

Example project: [A link to a minimal example that can reproduce the issue]

Expected behavior: [What you expected to happen]

Actual behavior: [What actually happened]

Any other information

Is there any other information you would like to add?

[jiqiang90]

Useful tickets:

graphile/pg-aggregates#25

graphile-contrib/postgraphile-plugin-connection-filter#152

[jiqiang90]

Waiting for help on graphile/pg-aggregates#36