v5.0.0

New issue

Open

No due date

•Last updated Oct 31, 2026

Everything that ships in 5.0.0, breaking or not. The label 'Breaking change' marks what is breaking.

3% complete

Reinstate Add LEFT() and RIGHT() SQL string functions to fix #590
AlaSQL/alasql#2262 · opened on Nov 20, 2025 · v5.0.0
1
Fix primary key enforcement for IndexedDB tables
Unread
#2274 with AI opened Nov 30, 2025 · Updated Oct 23, 2026Draft
3
Calling parser with backtick
Unread
#1512 opened Oct 5, 2022 · Updated Oct 23, 2026Draft
13
Add escape sequence support for string literals (\t, \n, \r, etc.)
Unread
#2331 with AI opened Dec 7, 2025 · Updated Oct 23, 2026Draft
11
Fix backslash escape handling in SQL string literals with performance optimization
Unread
#2335 with AI opened Dec 7, 2025 · Updated Oct 23, 2026
20
Add _all_ date function aliases to parser (extended)
Unread
#1982 opened Oct 22, 2024 · Updated Oct 23, 2026
29
[WIP] Add support for SQL-99 output format modifiers
Unread
#2376 with AI opened Dec 15, 2025 · Updated Oct 23, 2026
18
Make react-native-fs an optional peer dependency
Unread
#2456 opened Mar 29, 2026 · Updated Oct 23, 2026
3
Fix SUBSTRING with a non-positive start position
Unread
#2521 opened Aug 4, 2026 · Updated Oct 23, 2026
11
Refactor MAX and MIN functions to handle null values
Unread
#2480 opened Apr 19, 2026 · Updated Oct 23, 2026
5
Harden DELETE/UPDATE trigger edge cases and expand test coverage
Unread
#2552 with AI opened Sep 10, 2026 · Updated Oct 23, 2026Draft
One comparison module with levels (dates compared by value, MAX/MIN on strings, one NULL order)
AlaSQL/alasql#2595 · opened on Oct 14, 2026 · v5.0.0
Three-valued logic for NOT, AND, OR and IN with NULL (measured against SQLite)
AlaSQL/alasql#2597 · opened on Oct 14, 2026 · v5.0.0
SUBSTRING with a start of zero or below follows SQLite
AlaSQL/alasql#2598 · opened on Oct 14, 2026 · v5.0.0
3
Fix NULL handling in VAR, STDEV, VARP, STDEVP, STD and STDDEV (part of #2481)
Unread
#2581 opened Oct 12, 2026 · Updated Oct 23, 2026
1
Fix CAST/CONVERT of NULL returning 0, false or "undefined" to close #1208
Unread
#2576 opened Oct 12, 2026 · Updated Oct 23, 2026
2
Fix NOT IN with NULL in the subquery or list to close #1414
Unread
#2580 opened Oct 12, 2026 · Updated Oct 23, 2026
1
Evaluate UNION / EXCEPT / INTERSECT chains left to right to close #202
Unread
#2582 opened Oct 12, 2026 · Updated Oct 23, 2026
9
Return null, not undefined, for SQL NULL: what it means for the code
AlaSQL/alasql#2588 · opened on Oct 14, 2026 · v5.0.0
Implement LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions
Unread
#2444 opened Feb 16, 2026 · Updated Oct 23, 2026
15
Fix #1979: Add GETDATE, NOW as aliases and allow CURRENT_TIMESTAMP()
Unread
#2121 opened Jun 10, 2025 · Updated Oct 23, 2026
2
Composite foreign key with NULL in some columns: MATCH SIMPLE as SQLite
AlaSQL/alasql#2663 · opened on Oct 20, 2026 · v5.0.0
1
ROW_NUMBER() OVER (ORDER BY …) ignores the window's ORDER BY; PARTITION BY works only on already-sorted output
AlaSQL/alasql#2591 · opened on Oct 14, 2026 · v5.0.0
A recursive CTE that reaches maxCteIterations throws instead of returning a cut-off result
AlaSQL/alasql#2700 · opened on Oct 20, 2026 · v5.0.0
ALTER TABLE RENAME TO on a missing table throws instead of returning 1
AlaSQL/alasql#2706 · opened on Oct 20, 2026 · v5.0.0

Navigation Menu

v5.0.0

Reinstate Add LEFT() and RIGHT() SQL string functions to fix #590

Fix primary key enforcement for IndexedDB tables

Calling parser with backtick

Add escape sequence support for string literals (\t, \n, \r, etc.)

Fix backslash escape handling in SQL string literals with performance optimization

Add _all_ date function aliases to parser (extended)

[WIP] Add support for SQL-99 output format modifiers

Make `react-native-fs` an optional peer dependency

Fix SUBSTRING with a non-positive start position

Refactor MAX and MIN functions to handle null values

Harden DELETE/UPDATE trigger edge cases and expand test coverage

One comparison module with levels (dates compared by value, MAX/MIN on strings, one NULL order)

Three-valued logic for NOT, AND, OR and IN with NULL (measured against SQLite)

SUBSTRING with a start of zero or below follows SQLite

Fix NULL handling in VAR, STDEV, VARP, STDEVP, STD and STDDEV (part of #2481)

Fix CAST/CONVERT of NULL returning 0, false or "undefined" to close #1208

Fix NOT IN with NULL in the subquery or list to close #1414

Evaluate UNION / EXCEPT / INTERSECT chains left to right to close #202

Return null, not undefined, for SQL NULL: what it means for the code

Implement LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

Fix #1979: Add GETDATE, NOW as aliases and allow CURRENT_TIMESTAMP()

Composite foreign key with NULL in some columns: MATCH SIMPLE as SQLite

ROW_NUMBER() OVER (ORDER BY …) ignores the window's ORDER BY; PARTITION BY works only on already-sorted output

A recursive CTE that reaches maxCteIterations throws instead of returning a cut-off result

ALTER TABLE RENAME TO on a missing table throws instead of returning 1

Issues