Create View

CREATE VIEW

AlaSQL supports CREATE VIEW statement:

    alasql('create table city (name string, population number); \
            create view bigcity (name) as select name from city where population > 1000000; \
            insert into city values ("Moscow",11500000), ("Berlin", 3500000), ("Yoshkar-Ola",250000)');

    alasql('insert into city values ("New York",16000000)');

Try this example in jsFiddle