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