alasql/alasql (alasql)
### [`v4.1.2`](https://togithub.com/alasql/alasql/compare/v4.1.1...v4.1.2)
[Compare Source](https://togithub.com/alasql/alasql/compare/v4.1.1...v4.1.2)
### [`v4.1.1`](https://togithub.com/alasql/alasql/compare/v4.1.0...v4.1.1)
[Compare Source](https://togithub.com/alasql/alasql/compare/v4.1.0...v4.1.1)
### [`v4.1.0`](https://togithub.com/AlaSQL/alasql/releases/tag/v4.1.0): 2023-06-20
[Compare Source](https://togithub.com/alasql/alasql/compare/v4.0.6...v4.1.0)
- Fix [#1400](https://togithub.com/alasql/alasql/issues/1400) by providing an option to get the raw data from a csv file with no conversion to numbers. See [AlaSQL/alasql/wiki/CSV#options](https://togithub.com/AlaSQL/alasql/wiki/CSV#options) for details about the new `raw` option - thanks to [@Julias0](https://togithub.com/Julias0)
Full Changelog: https://github.com/AlaSQL/alasql/compare/v4.0.6...v4.1.0
### [`v4.0.6`](https://togithub.com/AlaSQL/alasql/releases/tag/v4.0.6): 2023-06-18
[Compare Source](https://togithub.com/alasql/alasql/compare/v4.0.5...v4.0.6)
- Fix [#1645](https://togithub.com/alasql/alasql/issues/1645): Variable assignment from query - thanks to [@Julias0](https://togithub.com/Julias0)
***
Full Changelog: https://github.com/AlaSQL/alasql/compare/v4.0.5...v4.0.6
### [`v4.0.5`](https://togithub.com/AlaSQL/alasql/releases/tag/v4.0.5): 2023-06-13
[Compare Source](https://togithub.com/alasql/alasql/compare/v4.0.4...v4.0.5)
- Fix [#1641](https://togithub.com/alasql/alasql/issues/1641) - Run async SQL in sequence instead of parallel.
***
Full Changelog: https://github.com/AlaSQL/alasql/compare/v4.0.4...v4.0.5
### [`v4.0.4`](https://togithub.com/AlaSQL/alasql/releases/tag/v4.0.4): 2023-06-08
[Compare Source](https://togithub.com/alasql/alasql/compare/v4.0.3...v4.0.4)
- Improve types to work with both require and import - thanks to [@leqwasd](https://togithub.com/leqwasd) !
### [`v4.0.3`](https://togithub.com/alasql/alasql/compare/v4.0.2...v4.0.3)
[Compare Source](https://togithub.com/alasql/alasql/compare/v4.0.2...v4.0.3)
### [`v4.0.2`](https://togithub.com/AlaSQL/alasql/releases/tag/v4.0.2): 2023-04-28
[Compare Source](https://togithub.com/alasql/alasql/compare/v4.0.1...v4.0.2)
- Fix [#1694](https://togithub.com/alasql/alasql/issues/1694): Use XLSX v0.19.3 to avoid CVE-2023-30533
Thank you to [@BirdboyBolu](https://togithub.com/BirdboyBolu) who made their first contribution in [https://github.com/AlaSQL/alasql/pull/1636](https://togithub.com/AlaSQL/alasql/pull/1636)
Full Changelog: https://github.com/AlaSQL/alasql/compare/v4.0.1...v4.0.2
### [`v4.0.1`](https://togithub.com/alasql/alasql/compare/v4.0.0...v4.0.1)
[Compare Source](https://togithub.com/alasql/alasql/compare/v4.0.0...v4.0.1)
### [`v4.0.0`](https://togithub.com/AlaSQL/alasql/releases/tag/v4.0.0): 2023-04-28
[Compare Source](https://togithub.com/alasql/alasql/compare/v3.1.0...v4.0.0)
- Breaking: Fix `order by` dates in queries with incomplete type information by [@Buroni](https://togithub.com/Buroni) in [https://github.com/AlaSQL/alasql/pull/1649](https://togithub.com/AlaSQL/alasql/pull/1649)
[Full Changelog](https://togithub.com/AlaSQL/alasql/compare/v3.1.0...v4.0.1)
### [`v3.1.0`](https://togithub.com/AlaSQL/alasql/releases/tag/v3.1.0): 2023-02-08
[Compare Source](https://togithub.com/alasql/alasql/compare/v3.0.0...v3.1.0)
**Summary**
- fix [#1415](https://togithub.com/alasql/alasql/issues/1415): UNION not returning correct result
**Details**
Details
#### What's Changed
* Bump eslint from 8.32.0 to 8.33.0 by @dependab[https://github.com/AlaSQL/alasql/pull/1626](https://togithub.com/AlaSQL/alasql/pull/1626)l/1626
* Bump http-cache-semantics from 4.1.0 to 4.1.1 by @dependab[https://github.com/AlaSQL/alasql/pull/1630](https://togithub.com/AlaSQL/alasql/pull/1630)l/1630
* Make test 251 compatibility with Windows by @swmm-[https://github.com/AlaSQL/alasql/pull/1632](https://togithub.com/AlaSQL/alasql/pull/1632)l/1632
* chore(deps): update dependency lint-staged to v13.1.1 by @renova[https://github.com/AlaSQL/alasql/pull/1633](https://togithub.com/AlaSQL/alasql/pull/1633)l/1633
* fix #1415: UNION not returning correct result by @amb[https://github.com/AlaSQL/alasql/pull/1629](https://togithub.com/AlaSQL/alasql/pull/1629)ql/pull/1629
#### New Contributors
* @swmm-js made their first contributi[https://github.com/AlaSQL/alasql/pull/1632](https://togithub.com/AlaSQL/alasql/pull/1632)l/1632
**Full Changelog**: https://github.com/AlaSQL/alasql/compare/v3.0.0...v3.1.0
### [`v3.0.0`](https://togithub.com/AlaSQL/alasql/releases/tag/v3.0.0): 2023-01-27
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.5.3...v3.0.0)
Fix [#1625](https://togithub.com/alasql/alasql/issues/1625): Deprecate WebSQL as Chrome [will remove support](https://developer.chrome.com/blog/deprecating-web-sql/)
### [`v2.5.3`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.5.3): 2023-01-20
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.5.2...v2.5.3)
**Summary**
- [#1616](https://togithub.com/alasql/alasql/issues/1616) fix `INSERT INTO` with a `SELECT * FROM` subquery
***
**Details**
- chore(deps): update dependency husky to v8 by [@renovate](https://togithub.com/renovate) in [https://github.com/AlaSQL/alasql/pull/1621](https://togithub.com/AlaSQL/alasql/pull/1621)
- fix(deps): update dependency yargs to v17 by [@renovate](https://togithub.com/renovate) in [https://github.com/AlaSQL/alasql/pull/1623](https://togithub.com/AlaSQL/alasql/pull/1623)
- fix(deps): update dependency node-fetch to v3 by [@renovate](https://togithub.com/renovate) in [https://github.com/AlaSQL/alasql/pull/1622](https://togithub.com/AlaSQL/alasql/pull/1622)
- Fix [#1616](https://togithub.com/alasql/alasql/issues/1616): INSERT INTO with a SELECT \* FROM and a subquery throws exception by [@ambujsahu81](https://togithub.com/ambujsahu81) in [https://github.com/AlaSQL/alasql/pull/1624](https://togithub.com/AlaSQL/alasql/pull/1624)
**Full Changelog**: https://github.com/AlaSQL/alasql/compare/v2.5.2...v2.5.3
### [`v2.5.2`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.5.2): 2023-01-18
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.5.1...v2.5.2)
**Summary**
- [#1618](https://togithub.com/alasql/alasql/issues/1618) fix: GROUP BY with CASE x IS NULL
- Clean up code base
Details
#### What's Changed
* Update dependency prettier to v2.8.2 by @renova[https://github.com/AlaSQL/alasql/pull/1606](https://togithub.com/AlaSQL/alasql/pull/1606)l/1606
* Remove all of jQuery by @jimmywarti[https://github.com/AlaSQL/alasql/pull/1599](https://togithub.com/AlaSQL/alasql/pull/1599)l/1599
* Refactor Select and ExistValue by @jimmywarti[https://github.com/AlaSQL/alasql/pull/1607](https://togithub.com/AlaSQL/alasql/pull/1607)l/1607
* Refactor to using classes by @jimmywarti[https://github.com/AlaSQL/alasql/pull/1609](https://togithub.com/AlaSQL/alasql/pull/1609)l/1609
* Update dependency prettier to v2.8.3 by @renova[https://github.com/AlaSQL/alasql/pull/1612](https://togithub.com/AlaSQL/alasql/pull/1612)l/1612
* Bump eslint-plugin-n from 15.6.0 to 15.6.1 by @dependab[https://github.com/AlaSQL/alasql/pull/1613](https://togithub.com/AlaSQL/alasql/pull/1613)l/1613
* Bump eslint-plugin-import from 2.26.0 to 2.27.4 by @dependab[https://github.com/AlaSQL/alasql/pull/1614](https://togithub.com/AlaSQL/alasql/pull/1614)l/1614
* Bump eslint from 8.31.0 to 8.32.0 by @dependab[https://github.com/AlaSQL/alasql/pull/1615](https://togithub.com/AlaSQL/alasql/pull/1615)l/1615
* Fix a dead link in Readme.md by @ambujsahu[https://github.com/AlaSQL/alasql/pull/1619](https://togithub.com/AlaSQL/alasql/pull/1619)l/1619
* fix: GROUP BY with CASE x IS NULL by @alsunduk[https://github.com/AlaSQL/alasql/pull/1618](https://togithub.com/AlaSQL/alasql/pull/1618)l/1618
* Bump eslint-plugin-import from 2.27.4 to 2.27.5 by @dependab[https://github.com/AlaSQL/alasql/pull/1617](https://togithub.com/AlaSQL/alasql/pull/1617)l/1617
**Full Changelog**: https://github.com/AlaSQL/alasql/compare/v2.5.1...v2.5.2
### [`v2.5.1`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.5.1): 2023-01-03
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.5.0...v2.5.1)
- Fix: Prototype Pollution in JSON5
- Set node engine requirements correctly in package.json
- Code refactoring
### [`v2.5.0`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.5.0): 2023-01-02
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.4.2...v2.5.0)
- [#1530](https://togithub.com/alasql/alasql/issues/1530) add: Support the SQL aggregator "total"
- [#1601](https://togithub.com/alasql/alasql/issues/1601) fix: Remove build info from version number
### [`v2.4.2`](https://togithub.com/alasql/alasql/compare/v2.4.1...v2.4.2)
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.4.1...v2.4.2)
### [`v2.4.1`](https://togithub.com/alasql/alasql/compare/v2.4.0...v2.4.1)
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.4.0...v2.4.1)
### [`v2.4.0`](https://togithub.com/alasql/alasql/compare/v2.3.0...v2.4.0)
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.3.0...v2.4.0)
### [`v2.3.0`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.3.0): 2022-12-29
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.2.5...v2.3.0)
- [#1596](https://togithub.com/alasql/alasql/issues/1596) fix: Remove XMLHttpRequest as Chrome no longer support sync calls
- Repo cleanup
- Remove support for ie9 specific code
- Remove bower support
- Typescript type definition moved in the repo (not in npm package)
### [`v2.2.5`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.2.5): 2022-12-24
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.2.4...v2.2.5)
- [#1588](https://togithub.com/alasql/alasql/issues/1588) fix: Better error reporting for order by
- General code refactoring
### [`v2.2.4`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.2.4): 2022-12-20
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.2.3...v2.2.4)
- [#1562](https://togithub.com/alasql/alasql/issues/1562) Fix: sync XMLHttpRequest
- [#1577](https://togithub.com/alasql/alasql/issues/1577) Fix: Run callback when creating indexeddb table
- [#877](https://togithub.com/alasql/alasql/issues/877) Fix: Avoid using the deprecated webkitGetDatabaseNames
### [`v2.2.3`](https://togithub.com/alasql/alasql/compare/v2.2.2...v2.2.3)
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.2.2...v2.2.3)
### [`v2.2.2`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.2.2): 2022-12-10
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.2.1...v2.2.2)
- Let Sum, max, min null value deal correctly with non numeric data to fix [#1533](https://togithub.com/alasql/alasql/issues/1533), [#1532](https://togithub.com/alasql/alasql/issues/1532) and [#1531](https://togithub.com/alasql/alasql/issues/1531)
### [`v2.2.1`](https://togithub.com/alasql/alasql/compare/v2.2.0...v2.2.1)
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.2.0...v2.2.1)
### [`v2.2.0`](https://togithub.com/alasql/alasql/compare/v2.1.8...v2.2.0)
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.1.8...v2.2.0)
### [`v2.1.8`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.1.8): 2022-11-29
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.1.7...v2.1.8)
- [#1548](https://togithub.com/alasql/alasql/issues/1548) Fix: Calculate columns beyond ZZ for excel export
### [`v2.1.7`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.1.7): 2022-11-27
[Compare Source](https://togithub.com/alasql/alasql/compare/v2.1.6...v2.1.7)
- [#1541](https://togithub.com/alasql/alasql/issues/1541) Fix: Remove depricated dependencies
- Clean: No built in Promise polifil
- Clean: No built in console
- Clean: Remove ESlint
Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
[ ] If you want to rebase/retry this PR, check this box
This PR has been generated by Mend Renovate. View repository job log here.
This PR contains the following updates:
2.1.6
->4.1.2
Release Notes
alasql/alasql (alasql)
### [`v4.1.2`](https://togithub.com/alasql/alasql/compare/v4.1.1...v4.1.2) [Compare Source](https://togithub.com/alasql/alasql/compare/v4.1.1...v4.1.2) ### [`v4.1.1`](https://togithub.com/alasql/alasql/compare/v4.1.0...v4.1.1) [Compare Source](https://togithub.com/alasql/alasql/compare/v4.1.0...v4.1.1) ### [`v4.1.0`](https://togithub.com/AlaSQL/alasql/releases/tag/v4.1.0): 2023-06-20 [Compare Source](https://togithub.com/alasql/alasql/compare/v4.0.6...v4.1.0) - Fix [#1400](https://togithub.com/alasql/alasql/issues/1400) by providing an option to get the raw data from a csv file with no conversion to numbers. See [AlaSQL/alasql/wiki/CSV#options](https://togithub.com/AlaSQL/alasql/wiki/CSV#options) for details about the new `raw` option - thanks to [@Julias0](https://togithub.com/Julias0) Full Changelog: https://github.com/AlaSQL/alasql/compare/v4.0.6...v4.1.0 ### [`v4.0.6`](https://togithub.com/AlaSQL/alasql/releases/tag/v4.0.6): 2023-06-18 [Compare Source](https://togithub.com/alasql/alasql/compare/v4.0.5...v4.0.6) - Fix [#1645](https://togithub.com/alasql/alasql/issues/1645): Variable assignment from query - thanks to [@Julias0](https://togithub.com/Julias0) *** Full Changelog: https://github.com/AlaSQL/alasql/compare/v4.0.5...v4.0.6 ### [`v4.0.5`](https://togithub.com/AlaSQL/alasql/releases/tag/v4.0.5): 2023-06-13 [Compare Source](https://togithub.com/alasql/alasql/compare/v4.0.4...v4.0.5) - Fix [#1641](https://togithub.com/alasql/alasql/issues/1641) - Run async SQL in sequence instead of parallel. *** Full Changelog: https://github.com/AlaSQL/alasql/compare/v4.0.4...v4.0.5 ### [`v4.0.4`](https://togithub.com/AlaSQL/alasql/releases/tag/v4.0.4): 2023-06-08 [Compare Source](https://togithub.com/alasql/alasql/compare/v4.0.3...v4.0.4) - Improve types to work with both require and import - thanks to [@leqwasd](https://togithub.com/leqwasd) ! ### [`v4.0.3`](https://togithub.com/alasql/alasql/compare/v4.0.2...v4.0.3) [Compare Source](https://togithub.com/alasql/alasql/compare/v4.0.2...v4.0.3) ### [`v4.0.2`](https://togithub.com/AlaSQL/alasql/releases/tag/v4.0.2): 2023-04-28 [Compare Source](https://togithub.com/alasql/alasql/compare/v4.0.1...v4.0.2) - Fix [#1694](https://togithub.com/alasql/alasql/issues/1694): Use XLSX v0.19.3 to avoid CVE-2023-30533 Thank you to [@BirdboyBolu](https://togithub.com/BirdboyBolu) who made their first contribution in [https://github.com/AlaSQL/alasql/pull/1636](https://togithub.com/AlaSQL/alasql/pull/1636) Full Changelog: https://github.com/AlaSQL/alasql/compare/v4.0.1...v4.0.2 ### [`v4.0.1`](https://togithub.com/alasql/alasql/compare/v4.0.0...v4.0.1) [Compare Source](https://togithub.com/alasql/alasql/compare/v4.0.0...v4.0.1) ### [`v4.0.0`](https://togithub.com/AlaSQL/alasql/releases/tag/v4.0.0): 2023-04-28 [Compare Source](https://togithub.com/alasql/alasql/compare/v3.1.0...v4.0.0) - Breaking: Fix `order by` dates in queries with incomplete type information by [@Buroni](https://togithub.com/Buroni) in [https://github.com/AlaSQL/alasql/pull/1649](https://togithub.com/AlaSQL/alasql/pull/1649) [Full Changelog](https://togithub.com/AlaSQL/alasql/compare/v3.1.0...v4.0.1) ### [`v3.1.0`](https://togithub.com/AlaSQL/alasql/releases/tag/v3.1.0): 2023-02-08 [Compare Source](https://togithub.com/alasql/alasql/compare/v3.0.0...v3.1.0) **Summary** - fix [#1415](https://togithub.com/alasql/alasql/issues/1415): UNION not returning correct result **Details**Details
#### What's Changed * Bump eslint from 8.32.0 to 8.33.0 by @dependab[https://github.com/AlaSQL/alasql/pull/1626](https://togithub.com/AlaSQL/alasql/pull/1626)l/1626 * Bump http-cache-semantics from 4.1.0 to 4.1.1 by @dependab[https://github.com/AlaSQL/alasql/pull/1630](https://togithub.com/AlaSQL/alasql/pull/1630)l/1630 * Make test 251 compatibility with Windows by @swmm-[https://github.com/AlaSQL/alasql/pull/1632](https://togithub.com/AlaSQL/alasql/pull/1632)l/1632 * chore(deps): update dependency lint-staged to v13.1.1 by @renova[https://github.com/AlaSQL/alasql/pull/1633](https://togithub.com/AlaSQL/alasql/pull/1633)l/1633 * fix #1415: UNION not returning correct result by @amb[https://github.com/AlaSQL/alasql/pull/1629](https://togithub.com/AlaSQL/alasql/pull/1629)ql/pull/1629 #### New Contributors * @swmm-js made their first contributi[https://github.com/AlaSQL/alasql/pull/1632](https://togithub.com/AlaSQL/alasql/pull/1632)l/1632 **Full Changelog**: https://github.com/AlaSQL/alasql/compare/v3.0.0...v3.1.0Details
#### What's Changed * Update dependency prettier to v2.8.2 by @renova[https://github.com/AlaSQL/alasql/pull/1606](https://togithub.com/AlaSQL/alasql/pull/1606)l/1606 * Remove all of jQuery by @jimmywarti[https://github.com/AlaSQL/alasql/pull/1599](https://togithub.com/AlaSQL/alasql/pull/1599)l/1599 * Refactor Select and ExistValue by @jimmywarti[https://github.com/AlaSQL/alasql/pull/1607](https://togithub.com/AlaSQL/alasql/pull/1607)l/1607 * Refactor to using classes by @jimmywarti[https://github.com/AlaSQL/alasql/pull/1609](https://togithub.com/AlaSQL/alasql/pull/1609)l/1609 * Update dependency prettier to v2.8.3 by @renova[https://github.com/AlaSQL/alasql/pull/1612](https://togithub.com/AlaSQL/alasql/pull/1612)l/1612 * Bump eslint-plugin-n from 15.6.0 to 15.6.1 by @dependab[https://github.com/AlaSQL/alasql/pull/1613](https://togithub.com/AlaSQL/alasql/pull/1613)l/1613 * Bump eslint-plugin-import from 2.26.0 to 2.27.4 by @dependab[https://github.com/AlaSQL/alasql/pull/1614](https://togithub.com/AlaSQL/alasql/pull/1614)l/1614 * Bump eslint from 8.31.0 to 8.32.0 by @dependab[https://github.com/AlaSQL/alasql/pull/1615](https://togithub.com/AlaSQL/alasql/pull/1615)l/1615 * Fix a dead link in Readme.md by @ambujsahu[https://github.com/AlaSQL/alasql/pull/1619](https://togithub.com/AlaSQL/alasql/pull/1619)l/1619 * fix: GROUP BY with CASE x IS NULL by @alsunduk[https://github.com/AlaSQL/alasql/pull/1618](https://togithub.com/AlaSQL/alasql/pull/1618)l/1618 * Bump eslint-plugin-import from 2.27.4 to 2.27.5 by @dependab[https://github.com/AlaSQL/alasql/pull/1617](https://togithub.com/AlaSQL/alasql/pull/1617)l/1617 **Full Changelog**: https://github.com/AlaSQL/alasql/compare/v2.5.1...v2.5.2Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR has been generated by Mend Renovate. View repository job log here.