The author of AlaSQL is Andrey Gershun, a Russian developer. The initial commit for AlaSQL on Github was on October 26, 2014.
In 2014, there were a handful of NoSQL in-memory databases that can be directly used in browser. The lack of a SQL compliant alternative motivated the AlaSQL project.
One of the major milestones/releases of the AlaSQL project is version 0.1.4 in which foreign keys, unique/not-null/check constraints were added. In version 0.4.0, support for Typescript syntax checking was added.
All SQL join types are supported. Prior to executing a join, both tables are pre-indexed, and WHERE predicates are evaluated.
Concurrency control is not supported, nor is parallel execution.