CREATE FOREIGN TABLE  Customer (
                CustomerId integer PRIMARY KEY,
                FirstName varchar(25),
                LastName varchar(25)
            ) OPTIONS(UPDATABLE 'TRUE');
             
            CREATE FOREIGN TABLE Address (
                CustomerId integer PRIMARY KEY,
                Street varchar(50),
                City varchar(25),
                State varchar(25),
                Zipcode varchar(6),
                FOREIGN KEY (CustomerId) REFERENCES Customer (CustomerId)
             ) OPTIONS(UPDATABLE 'TRUE', "teiid_mongo:MERGE" 'Customer');

insert into Customer (customerId ,firstname,lastname) values ('1002','Syed','Iqbal');
insert into Address (customerId,street,city,state,zipcode) values ('1002','123 Main St','Chicago','IL','60659');
insert into Customer (customerId ,firstname,lastname) values ('1000','Ramesh','Reddy');

{
	"Address" : {
		"Street" : "123 Main St",
		"City" : "Chicago",
		"State" : "IL",
		"Zipcode" : "60659",
		"_id" : DBRef("Customer", 1002)
	},
	"FirstName" : "Syed",
	"LastName" : "Iqbal",
	"Notes" : [ ],
	"_id" : 1002
}
{ "_id" : 1000, "FirstName" : "Ramesh", "LastName" : "Reddy" }

SELECT * FROM Address