I want to create a `@relationTargetColumn` smart comment, for making relationships that target only a single column in a table instead of an entire object. Ideally, other columns on the relationship should appear in the edge data. This is an example of what I want to create, but I'm not sure what's the best way to get started...

1-schema.sql

drop schema if exists sh cascade;
create schema sh;

create table sh.hero (
  id serial primary key,
  species text
);

create table sh.hero_name (
  id serial primary key,
  hero_id int not null constraint hero_name_hero_id_fkey references sh.hero (id),
  name text not null,
  category text
);

comment on constraint hero_name_hero_id_fkey on sh.hero_name is
  E'@foreignFieldName names\n@relationTargetColumn name';
  

2-data.sql

insert into sh.hero (id, species) values
  (1, 'Kryptonian'),
  (2, 'Amazonian'),
  (3, 'Human');

insert into sh.hero_name (id, hero_id, name, category) values
  (1, 1, 'Superman', 'Hero'),
  (2, 1, 'The Man of Steel', 'Title'),
  (3, 1, 'Clark Kent', 'Civilian'),
  (4, 2, 'Wonder Woman', 'Hero'),
  (5, 2, 'Princess Diana of Themyscira', 'Amazonian'),
  (6, 2, 'Diana Prince', 'Civilian'),
  (7, 3, 'Batman', 'Hero'),
  (8, 3, 'The Dark Knight', 'Title'),
  (9, 3, 'Bruce Wayne', 'Civilian');

3-query.graphql

{
  allHeroes {
    nodes {
      species
      names {
        edges {
          category
          node {
            name
          }
        }
      }
    }
  }
}