How to add condition for a table that is related to other(while joining tables)
<!-- Before opening an issue: if you use `npm` try running `yarn` instead; if
      you run `yarn`, please try running `npx yarn-deduplicate && yarn`. -->

<!-- You can also chat with us on Discord: http://discord.gg/graphile -->

### Summary
We have two tables AAAA and BBBB. Now I am trying to joining AAAA with BBBB and getting some data based on conditions

```graphql
{
  AAAA(filter: {ab: {isNull: false}}) {
    nodes {
      id
      BBBB{
        type
      }
    }
    totalCount
  }
}
```

Here I need to add a condition where my type is "ccdd" in table BBBB


<!-- Please detail the issue you'd like to discuss. -->

### Additional context

<!-- Please provide additional context such as environment versions (including
      operating system, Node, PostgreSQL, Redis, etc. as relevant), software
      versions (from `yarn.lock`) or similar, plugins in use, database schema
      if relevant, bundler (if any). -->
