Return array of type from array column
<!-- 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've defined a table as:

```sql
CREATE TABLE comments (
  id uuid NOT NULL DEFAULT uuid_generate_v4() UNIQUE,
  comment text NOT NULL,
  created_at timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
  mentions uuid[] NOT NULL DEFAULT '{}'::uuid[],
  updated_at timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
  user_profile_id uuid NOT NULL
);
```

Where the `mentions` column is an array of UUID that corresponds to a `user_profiles` table.

I'm looking for a way to define a smart comment that will allow me to return a `mentionedUsers` array of users out of `user_profiles` for a comment.  I spent some time on the googs and browsing issues here, but couldn't find anything that corresponded.

Any suggestions?

### 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). -->
