Curious how others handle this - running into it across three different shapes of project: Legacy schemas where someone never added the FK constraint, so the column is just an int. Warehouse / analytics tables that intentionally skip FKs for load performance. Polymorphic columns (Rails-style commentable_id + commentable_type) where a single FK constraint isn't even technically possible. In all three the relationship is real and gets joined constantly, but pgAdmin / DBeaver / DataGrip don't know about it, so the cell isn't clickable, there's no row preview, no related-data tab. You end up writing the JOIN by hand every time. What's your workflow? Is there a tool that lets you declare relationships locally without touching the schema? Documentation in a wiki? Just memorize it?…