Aliases help lookup but must resolve to stable identifiers before joins.
Aliases are not safe primary keys
Aliases help humans search, but aliases can merge, split, or collide. This slice has 4 records with aliases.
alias rows=4
Resolve aliases before joining data
The safe workflow is resolve first, then join by identifier. The canonical label is display text; it is not the database key.
alias→identifier→join