All pull requests

Pull requests

• Step 5: expressions and functions as ES modules

  #2839·mathiasrw opened Oct 21, 2026Member·

  ·

• Step 4, second part: the Database, Table, View and Transaction classes as ES modules

  #2838·mathiasrw opened Oct 21, 2026Member·

  ·

• Move schemaChanged, returnTrue, n2u, und and getXLSX from alasql.private to internal

  #2837·mathiasrw opened Oct 21, 2026Member·

  ·

• Add the complete benchmark dataset for the 22 dimensions

  #2752·mathiasrw opened Oct 21, 2026Member·

  ·

• Take ^, $, \ and escaped characters literally in LIKE and GLOB to close #2748

  #2749·mathiasrw opened Oct 21, 2026Member·

  ·

  · Breaking change (for v5.0.0)
  1

  1

• Make GREATEST and LEAST return NULL consistently to close #2583

  #2735·vaibh14yadav-tech opened Oct 20, 2026·

  ·

  · Breaking change (for v5.0.0)
  1

  1

• fix: follow SQLite for SUBSTRING with start <= 0 and add FROM/FOR syntax (#2598)

  #2734·manas24103 opened Oct 20, 2026·

  ·

  · Breaking change (for v5.0.0)
  1

  1

• Pass defcols to the arguments of built-in functions to close #2615

  #2619·mathiasrw opened Oct 20, 2026Member·

  ·

  · Breaking change (for v5.0.0)
  1

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

  #2582·joshuablac opened Oct 12, 2026Contributor·

  ·

  · Breaking change (for v5.0.0)
  1

  9

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

  #2581·joshuablac opened Oct 12, 2026Contributor·

  ·

  · Breaking change (for v5.0.0)
  1

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

  #2580·joshuablac opened Oct 12, 2026Contributor·

  ·

  · Breaking change (for v5.0.0)
  1

  1

• Fix database.table.column references throwing to close #2186

  #2578·joshuablac opened Oct 12, 2026Contributor·

  ·

  · v5.x Focus
  1

  3

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

  #2576·joshuablac opened Oct 12, 2026Contributor·

  ·

  · Breaking change (for v5.0.0)
  1

  2

• Harden DELETE/UPDATE trigger edge cases and expand test coverage

  #2552·mathiasrw with CopilotAI opened Sep 10, 2026·

  ·

  · Breaking change (for v5.0.0)
  1

  

• [WIP] Implement LET clause similar to OrientDB

  #2535·mathiasrw with CopilotAI opened Aug 25, 2026·1 of 5 tasks·

  ·

  · The Back Burner
  1

  12

  

• Fix SUBSTRING with a non-positive start position

  #2521·spokodev opened Aug 4, 2026·

  ·

  · Breaking change (for v5.0.0)
  11

• Refactor MAX and MIN functions to handle null values

  #2480·Aston8 opened Apr 19, 2026·

  ·

  · Breaking change (for v5.0.0)
  5

  

• Make react-native-fs an optional peer dependency

  #2456·ej612 opened Mar 29, 2026·

  ·

  · Breaking change (for v5.0.0)
  1

  3

• Implement LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

  #2444·apoorvdarshan opened Feb 16, 2026·5 tasks done·

  ·

  · Breaking change (for v5.0.0)
  1

  15

• Implement LEAD, LAG, FIRST_VALUE, and LAST_VALUE window functions

  #2412·mathiasrw with CopilotAI opened Dec 23, 2025·14 tasks done·

  ·
  1

  25

  

• [WIP] Implement MERGE statement execution logic

  #2410·mathiasrw with CopilotAI opened Dec 23, 2025·14 tasks done·

  ·

  · The Back Burner
  1

  15

  

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

  #2376·mathiasrw with CopilotAI opened Dec 15, 2025·8 of 19 tasks·

  ·

  · Breaking change (for v5.0.0)
  18

  

• Implement CASCADE behavior enforcement for FOREIGN KEY constraints

  #2337·mathiasrw with CopilotAI opened Dec 11, 2025·

  ·

  · The Back Burner
  1

  8

  

• Fix backslash escape handling in SQL string literals with performance optimization

  #2335·mathiasrw with CopilotAI opened Dec 7, 2025·10 tasks done·

  ·

  · Breaking change (for v5.0.0)
  1

  20

  

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

  #2331·mathiasrw with CopilotAI opened Dec 7, 2025·

  ·

  · Breaking change (for v5.0.0)
  1

  11