SELECT a.id AS a_id, a.company_id AS a_cid, b.id AS b_id FROM Person a INNER JOIN Company b IN a.company_id = b.id

CREATE FOREIGN TABLE Person (
    id integer PRIMARY KEY,
    name varchar(25),
    company_id integer,
    FOREIGN KEY (company_id) REFERENCES Company (id)
) OPTIONS(UPDATABLE 'TRUE');

CREATE FOREIGN TABLE Company (
    id integer PRIMARY KEY,
    name varchar(25)
) OPTIONS(UPDATABLE 'TRUE', "teiid_mongo:EMBEDDABLE" 'TRUE');