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)