Implicit foreign key joins

[KyGost]

Being able to query tables with partner tables as if they were the same table would be pretty cool.

Not sure if this should be allowed for one-to-many tables.

Example:

SELECT
  person.id,
  person.name,
  person.phone,
  emergency_contact.name,
  emergency_contact.phone
FROM
  person

where

CREATE TABLE person (
  id UINT PRIMARY KEY,
  name SMALL_TEXT,
  phone SMALL_TEXT,
  emergency_contact_id INT FOREIGN KEY REFERENCES person (id)
)
-- Foreign Key doesn't need to be same table, better example could have been used