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.
Concurrency control is not supported, nor is parallel execution.
All SQL join types are supported. Prior to executing a join, both tables are pre-indexed, and WHERE predicates are evaluated.