2022-10-25

• Add: Use --ast flag to print AST instead of result for CLI
• Add: Config option for infinite loop break with alasql.options.loopbreak
• #1491 Fix: Support lower case MEDIAN

2022-10-09

• #1519 Fix: Better error handling when reading files

2022-10-06

• Fix: cli for global install

2022-10-01

• #1268 Add: IN + NOT IN for strings and numbers
• #1268 Fix: ORDER BY for several columns

2022-10-01

• #1428 fix: Let DATEADD take month lengths into account

2022-09-30

• #1508 fix: COALESCE with null argument

2022-09-24

Summary

• #395 Breaking: Dates from Excel files will be loaded as JS date objects instead of the raw excel format for dates.
  • Add: Pass config when reading XLSX files (lets you revert to the old behaviour with dates)
• #1287 Breaking: NOW() will return - instead of . between year, month and day to align better to the JS ecosystem.
• #1449 Add: Query HTML in server side Node (in combination with JSDom)
• #1495 Add: TIMESTAMPDIFF from MYSQL
• #1350 Fix: Generated xlsx file in alasql has more columns in range than actual data
• #1426 Fix: AST to string causes double aliases
• #1433 Fix: IFNULL check for undefined and null
• #1419 Fix: Let CONCAT_WS ignore null and undefined
• #1467 Fix: Improve typings
• #1405 Fix: More robust CLI execution

Details

What's Changed

• Return empty results in group by when input is empty by @forestfang-stripe in #1279
• Fixed a typo by @melkecelioglu in #1410
• Fix #1350 by @mathiasrw in #1388
• XLSX configure to read cell dates as js date obj by @barakplasma in #1481
• Fix: AST to string causes double aliases by @Buroni in #1459
• FIX #1433: IFNULL checks only undefined and null by @leobia in #1434
• Check for global document rather than exports with INTO HTML by @brettz9 in #1449
• Break: NOW() returning ISO format by @alsundukov in #1431
• fix: Let CONCAT_WS ignore null by @alsundukov in #1419
• Add: TIMESTAMPDIFF from MYSQL by @mathiasrw in #1495

New Contributors

• @melkecelioglu made their first contribution in #1410
• @barakplasma made their first contribution in #1481
• @Buroni made their first contribution in #1459
• @leobia made their first contribution in #1434

Full Changelog: v0.6.5...v2.0.1

1.7.2 (2021-03-06)

Semver for the win

11.11.2020

• Fix: Do not include null in COUNT or AVG fixes #1251

(24.09.2020)

• Add: String and Number objects supported as values
• Add: JOIN USING now supports String and Number objects
• Fix: File naming when exporting to Exel