Issues

• v5: SUBSTRING with a start of zero or below follows SQLite

  Breaking changeRelated to: SQL compliance
  AlaSQL/alasql#2598 · Filter by author mathiasrw opened on Oct 14, 2026 · Breaking change

• v5: three-valued logic for NOT, AND, OR and IN with NULL (measured against SQLite)

  Breaking changeRelated to: SQL compliance
  AlaSQL/alasql#2597 · Filter by author mathiasrw opened on Oct 14, 2026 · Breaking change

• Cached statements hold per-run state, so two runs of the same SQL at once overwrite each other

  Bug: Code provided to reproducedRelated to: Code quality
  AlaSQL/alasql#2596 · Filter by author mathiasrw opened on Oct 14, 2026

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

  Breaking changeRelated to: PerformanceRelated to: SQL compliance
  AlaSQL/alasql#2595 · Filter by author mathiasrw opened on Oct 14, 2026 · Breaking change

• sqllogictest: what the results say (88%, NULL behaviour is the largest kind) and what to run next

  Related to: SQL complianceRelated to: Tests
  AlaSQL/alasql#2594 · Filter by author mathiasrw opened on Oct 14, 2026 · SQL logic test

• Oracle test: compare alasql with SQLite expression by expression in CI (the reference engine for v5)

  Related to: SQL complianceRelated to: Tests
  AlaSQL/alasql#2593 · Filter by author mathiasrw opened on Oct 14, 2026

• Precompile proof of concept: compile tagged queries at build time with the engine's own compiler, run without new Function

  Related to: Modular structure
  AlaSQL/alasql#2592 · Filter by author mathiasrw opened on Oct 14, 2026 · Focus

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

  Bug: Code provided to reproducedRelated to: SQL compliance
  AlaSQL/alasql#2591 · Filter by author mathiasrw opened on Oct 14, 2026

• CAST(NULL AS INTEGER) returns 0, not NULL (and other types return false, 'undefined' or a 1970 date)

  Bug: Code provided to reproducedRelated to: SQL compliance
  AlaSQL/alasql#2590 · Filter by author mathiasrw opened on Oct 14, 2026 · SQL logic test
  1

• Idea: live queries (subscribe to a query and be called again when its data changes)

  ideas
  AlaSQL/alasql#2589 · Filter by author mathiasrw opened on Oct 14, 2026

• v5: return null, not undefined, for SQL NULL: what it means for the code

  Breaking change
  AlaSQL/alasql#2588 · Filter by author mathiasrw opened on Oct 14, 2026 · Focus

• Statement cache returns another query's result when two SQL texts share a hash

  Bug: Code provided to reproduced
  AlaSQL/alasql#2587 · Filter by author mathiasrw opened on Oct 14, 2026

• Declare alasql.compile(), function-call nodes and -> operands in the published types

  AlaSQL/alasql#2585 · Filter by author assapir opened on Oct 13, 2026

• Accept any iterable as a data source (Set, Map, generator) and offer results as an iterator

  AlaSQL/alasql#2584 · Filter by author mathiasrw opened on Oct 13, 2026

• GREATEST / LEAST (scalar MAX / MIN) give order-dependent results when an argument is NULL

  AlaSQL/alasql#2583 · Filter by author mathiasrw opened on Oct 13, 2026 · ES6 src

• Published tarball vendors SheetJS under modules/xlsx — ~7.4 MB of the 9.3 MB install, carried by every consumer

  AlaSQL/alasql#2516 · Filter by author tps-flint opened on Jul 28, 2026 · ES6 src
  1

• Issues with aggregate functions, date handling, null handling: GREATEST, LEAST, MAX, MIN, VAR, STDEV, VARP, QUART/2/3

  AlaSQL/alasql#2481 · Filter by author gabrielmongefranco opened on Apr 19, 2026
  1

• Scalar subquery in SELECT fails when used inside derived table in FROM (possibly related to #1264)

  Good first issueHelp wantedRelated to: SQL compliance
  AlaSQL/alasql#2476 · Filter by author Victorabade opened on Apr 17, 2026
  1

  

• Window Offset Functions (LEAD/LAG/FIRST_VALUE/LAST_VALUE) Not Implemented

  AlaSQL/alasql#2409 · Filter by author mathiasrw opened on Dec 22, 2025

• UPSERT/MERGE Statement Not Implemented

  AlaSQL/alasql#2407 · Filter by author mathiasrw opened on Dec 22, 2025
  

• Graph & Search Extensions - Advanced Query Language Features

  AlaSQL/alasql#2367 · Filter by author mathiasrw opened on Dec 13, 2025

• Edge Cases & Other Features - Miscellaneous Functionality

  AlaSQL/alasql#2366 · Filter by author mathiasrw opened on Dec 13, 2025

• Triggers - Database Event Automation Support

  AlaSQL/alasql#2365 · Filter by author mathiasrw opened on Dec 13, 2025
  

• Output Formats - Query Result Modifiers Support

  AlaSQL/alasql#2364 · Filter by author mathiasrw opened on Dec 13, 2025

• Analise pending tests

  AlaSQL/alasql#2353 · Filter by author mathiasrw opened on Dec 13, 2025