How can I model a relationship between tables that don’t have a foreign key?
Hey there, @alexmorgan 
You can manually define a Relationship metadata object and map the fields explicitly.
Additionally, our VS Code extension will assist you in authoring your metadata 
It’s got pre-baked LSP under the hood, which gives you a tight feedback loop while working in your editor and has holistic knowledge of your entire supergraph.