2026-10-21

• Make subqueries in JOIN Read files (#2676)
• Make DEFAULT a context-aware keyword (#2683)
• Make SELECT alias for HAVING to close #887 (#2672)
• Make Call INTO XLS without options object to close #2639 (#2641)
• Make VALUE/VALUES a context-aware keyword to close #2022 (#2203)
• Make double-quoted identifiers in CREATE TABLE to close #989 (#2601)
• Make SOURCE and REQUIRE read files through alasql.utils.loadFile (#1610)
• Make quoted units in DATEADD, DATEDIFF and TIMESTAMPDIFF to close #2616 (#2669)
• Fix CUBE and GROUPING SETS merging groups from different sets to close #644 (#2577)
• Fix cached statements and views again after a schema change to close #2613 (#2620)
• Fix ORDER BY / LIMIT for SELECT on a set operation to close #2605 (#2608)
• Fix Promise.all concurrency cache collision to close #1953 (#2465)
• Fix global variable from ROUND and grouped aggregates (#2694)
• Fix ALTER TABLE RENAME TO and SHOW CREATE TABLE (#2704)
• Fix cache invalidation after table change close #2603 (#2609)
• Fix joined subqueries in expressions to close #832 (#2579)
• Fix index creation in CREATE TABLE to close #2607 (#2614)
• Fix order keys in a set operation to close #2610 (#2611)
• Fix ALTER TABLE ADD COLUMN to close #1107 (#2551)
• Fix ESCAPE in the text of a LIKE expression (#2674)
• Fix JSON file error handling to close #1314 (#2513)
• Fix reading of scientific notation numbers (#2695)
• Fix toString() for ARRAY[...] (#2691)
• Fix DISTINCT in any case (#2673)
• Fix CALL arguments (#2686)
• Improve Cache for LIKE (#2671)
• Improve caching for alasql.compile() (#2747)
• Improve BREAK and CONTINUE for async calls (#2701)
• Improve error message for BREAK and CONTINUE (#2703)
• Improve performance for recursive CTE with UNION (#2697)
• Improve error handlign for ORDER BY ... COLLATE NOCASE (#2719)
• Improve message in foreign key errors instead of undefined (#2664)

Thank you to the new contributors

• @Anikesh0001 made their first contribution in #2608
• @joshuablac made their first contribution in #2579
• @Lay-quq made their first contribution in #2601
• @AaryavGangrade made their first contribution in #2568
• @imsanupm made their first contribution in #2465

Full Changelog: v4.20.1...v4.21.0