text: CREATE DATABASE customer OPTIONS (ANNOTATION 'Customer VDB');
  USE DATABASE customer;
  
  CREATE SERVER sampledb TYPE 'NONE' FOREIGN DATA WRAPPER postgresql;
  
  CREATE SCHEMA accounts SERVER sampledb;
  CREATE VIRTUAL SCHEMA portfolio;
  
  SET SCHEMA accounts;
  IMPORT FOREIGN SCHEMA public FROM SERVER sampledb INTO accounts;
  
  SET SCHEMA portfolio;
  
  CREATE VIEW CustomerZipCode(id bigint PRIMARY KEY, name string, ssn string, zip string) AS 
      SELECT c.ID as id, c.NAME as name, c.SSN as ssn, a.ZIP as zip 
      FROM accounts.CUSTOMER c LEFT OUTER JOIN accounts.ADDRESS a 
      ON c.ID = a.CUSTOMER_ID;