See #845. We want the new lookup API to support a few more cases: - where there's a composite primary key (e.g., for built-in roles and update artifacts) and "id" is usually not present - where there's no "name" column (e.g., for sleds, silo users)