Foreign key / name interchangeability

Look up a familiar name instead of memorizing an id; SQLly follows the relationship for you.

Databases are fond of ids; people are usually fond of names. With column introspection configured, SQLly will let you search by name and insert the id, following the foreign key when you complete WHERE CustomerId = .

Configuring interchangeability

1. Point an id column at the display column on its referenced table, such as Customer.Name.
2. SQLly follows the foreign key when completion is requested for that id column.
3. Type the readable name and SQLly inserts the matching id.

Builds on table value introspection and the declared foreign keys from schema awareness.