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.
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.