npm / alasql
alasql
What changed in alasql 4, from its official release notes, upgrade guides and advisories. Sources checked 2026-10-25.
1 breaking3 performance3 behavior and defaults30 fixes and other
See which of these apply to your code, ranked, in your agent:
npx @unstale/cli initalasql 437 changes
Breaking changes 1
Fixes ordering dates in queries with incomplete type information.
Performance 3
Improves caching for alasql.compile().
Improves caching for LIKE.
Improves performance for recursive CTE with UNION.
Behavior and default changes 3
SOURCE and REQUIRE read files through alasql.utils.loadFile.
DEFAULT is now a context-aware keyword.
Subqueries in JOIN can read files.
Fixes and other changes 30
Fixes ALTER TABLE ADD COLUMN.
Fixes ALTER TABLE RENAME TO and SHOW CREATE TABLE.
Fixes toString() for ARRAY expressions.
Improves BREAK and CONTINUE for async calls.
Improves the error message for BREAK and CONTINUE.
Fixes cache invalidation after a table change.
Cached statements and views are fixed after a schema change.
Fixes CALL arguments.
CREATE TABLE supports double-quoted identifiers.
Fixes index creation in CREATE TABLE.
Fixes groups from different sets being merged.
DATEADD supports quoted units.
DATEDIFF supports quoted units.
Fixes DISTINCT in any case.
Foreign key errors show an improved message instead of undefined.
Fixes groups from different sets being merged.
SELECT aliases can be used in HAVING.
CALL INTO XLS works without an options object.
Fixes joined subqueries in expressions.
Fixes JSON file error handling.
Fixes ESCAPE in the text of a LIKE expression.
Improves error handling for ORDER BY ... COLLATE NOCASE.
Fixes ORDER BY and LIMIT for SELECT on a set operation.
Fixes concurrency cache collisions when using Promise.all.
Fixes a global variable issue involving ROUND and grouped aggregates.
Fixes reading of scientific notation numbers.
Fixes order keys in a set operation.
Fixes ALTER TABLE RENAME TO and SHOW CREATE TABLE.
TIMESTAMPDIFF supports quoted units.
VALUE and VALUES are now context-aware keywords.