search

koopjs / winnow

Deprecated
Apache License 2.0
90 stars 18 forks source link

Update dependency alasql to v3 #223

Closed renovate[bot] closed 1 year ago

renovate[bot] commented 1 year ago

Mend Renovate

This PR contains the following updates:

Package Change Age Adoption Passing Confidence
alasql ^1.0.0 -> ^3.0.0 age adoption passing confidence

Release Notes

alasql/alasql ### [`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 ### [`v2.1.6`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.1.6): 2022-10-26 [Compare Source](https://togithub.com/alasql/alasql/compare/v2.1.5...v2.1.6) **Highlight** - [#​1466](https://togithub.com/alasql/alasql/issues/1466) fix: IS NOT TRUE bug
Details #### What's Changed * Fix #​1466: IS NOT TRUE not working by @​m[https://github.com/AlaSQL/alasql/pull/1527](https://togithub.com/AlaSQL/alasql/pull/1527)ql/pull/1527 **Full Changelog**: https://github.com/AlaSQL/alasql/compare/v2.1.5...v2.1.6
### [`v2.1.5`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.1.5): 2022-10-25 [Compare Source](https://togithub.com/alasql/alasql/compare/v2.1.4...v2.1.5) - Add: Use `--ast` flag to print AST instead of result for CLI - Add: Config option for infinite loop break with `alasql.options.loopbreak` - [#​1491](https://togithub.com/alasql/alasql/issues/1491) Fix: Support lower case MEDIAN ### [`v2.1.4`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.1.4): 2022-10-09 [Compare Source](https://togithub.com/alasql/alasql/compare/v2.1.3...v2.1.4) - [#​1519](https://togithub.com/alasql/alasql/issues/1519) Fix: Better error handling when reading files ### [`v2.1.3`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.1.3): 2022-10-06 [Compare Source](https://togithub.com/alasql/alasql/compare/v2.1.2...v2.1.3) - Fix: cli for global install ### [`v2.1.2`](https://togithub.com/alasql/alasql/compare/v2.1.1...v2.1.2) [Compare Source](https://togithub.com/alasql/alasql/compare/v2.1.1...v2.1.2) ### [`v2.1.1`](https://togithub.com/alasql/alasql/compare/v2.1.0...v2.1.1) [Compare Source](https://togithub.com/alasql/alasql/compare/v2.1.0...v2.1.1) ### [`v2.1.0`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.1.0): 2022-10-01 [Compare Source](https://togithub.com/alasql/alasql/compare/v2.0.7...v2.1.0) - [#​1268](https://togithub.com/alasql/alasql/issues/1268) Add: IN + NOT IN for strings and numbers - [#​1268](https://togithub.com/alasql/alasql/issues/1268) Fix: ORDER BY for several columns ### [`v2.0.7`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.0.7): 2022-10-01 [Compare Source](https://togithub.com/alasql/alasql/compare/v2.0.6...v2.0.7) - [#​1428](https://togithub.com/alasql/alasql/issues/1428) fix: Let DATEADD take month lengths into account ### [`v2.0.6`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.0.6): 2022-09-30 [Compare Source](https://togithub.com/alasql/alasql/compare/v2.0.5...v2.0.6) - [#​1508](https://togithub.com/alasql/alasql/issues/1508) fix: COALESCE with null argument ### [`v2.0.5`](https://togithub.com/alasql/alasql/compare/v2.0.3...v2.0.5) [Compare Source](https://togithub.com/alasql/alasql/compare/v2.0.3...v2.0.5) ### [`v2.0.3`](https://togithub.com/alasql/alasql/compare/v2.0.2...v2.0.3) [Compare Source](https://togithub.com/alasql/alasql/compare/v2.0.2...v2.0.3) ### [`v2.0.2`](https://togithub.com/alasql/alasql/compare/v2.0.1...v2.0.2) [Compare Source](https://togithub.com/alasql/alasql/compare/v2.0.1...v2.0.2) ### [`v2.0.1`](https://togithub.com/AlaSQL/alasql/releases/tag/v2.0.1): 2022-09-24 [Compare Source](https://togithub.com/alasql/alasql/compare/04b99c4233d6f39b334c9d8144f9b1d09ba41b12...v2.0.1) **Summary** - [#​395](https://togithub.com/alasql/alasql/issues/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](https://togithub.com/alasql/alasql/issues/1287) Breaking: NOW() will return `-` instead of `.` between year, month and day to align better to the JS ecosystem. - [#​1449](https://togithub.com/alasql/alasql/issues/1449) Add: Query HTML in server side Node (in combination with JSDom) - [#​1495](https://togithub.com/alasql/alasql/issues/1495) Add: TIMESTAMPDIFF from MYSQL - [#​1350](https://togithub.com/alasql/alasql/issues/1350) Fix: Generated xlsx file in alasql has more columns in range than actual data - [#​1426](https://togithub.com/alasql/alasql/issues/1426) Fix: AST to string causes double aliases - [#​1433](https://togithub.com/alasql/alasql/issues/1433) Fix: IFNULL check for undefined and null - [#​1419](https://togithub.com/alasql/alasql/issues/1419) Fix: Let CONCAT_WS ignore null and undefined - [#​1467](https://togithub.com/alasql/alasql/issues/1467) Fix: Improve typings - [#​1405](https://togithub.com/alasql/alasql/issues/1405) Fix: More robust CLI execution
Details #### What's Changed * Return empty results in group by when input is empty by @​forestfang-stri[https://github.com/AlaSQL/alasql/pull/1279](https://togithub.com/AlaSQL/alasql/pull/1279)l/1279 * Fixed a typo by @​melkeceliog[https://github.com/AlaSQL/alasql/pull/1410](https://togithub.com/AlaSQL/alasql/pull/1410)l/1410 * Fix #​1350 by @​m[https://github.com/AlaSQL/alasql/pull/1388](https://togithub.com/AlaSQL/alasql/pull/1388)ql/pull/1388 * XLSX configure to read cell dates as js date obj by @​barakplas[https://github.com/AlaSQL/alasql/pull/1481](https://togithub.com/AlaSQL/alasql/pull/1481)l/1481 * Fix: AST to string causes double aliases by @​Buro[https://github.com/AlaSQL/alasql/pull/1459](https://togithub.com/AlaSQL/alasql/pull/1459)l/1459 * FIX #​1433: IFNULL checks only undefined and null by @̴[https://github.com/AlaSQL/alasql/pull/1434](https://togithub.com/AlaSQL/alasql/pull/1434)ql/pull/1434 * Check for global `document` rather than `exports` with INTO HTML by @​brett[https://github.com/AlaSQL/alasql/pull/1449](https://togithub.com/AlaSQL/alasql/pull/1449)l/1449 * Break: NOW() returning ISO format by @​alsunduk[https://github.com/AlaSQL/alasql/pull/1431](https://togithub.com/AlaSQL/alasql/pull/1431)l/1431 * fix: Let CONCAT_WS ignore null by @​alsunduk[https://github.com/AlaSQL/alasql/pull/1419](https://togithub.com/AlaSQL/alasql/pull/1419)l/1419 * Add: TIMESTAMPDIFF from MYSQL by @​mathias[https://github.com/AlaSQL/alasql/pull/1495](https://togithub.com/AlaSQL/alasql/pull/1495)l/1495 #### New Contributors * @​melkecelioglu made their first contributi[https://github.com/AlaSQL/alasql/pull/1410](https://togithub.com/AlaSQL/alasql/pull/1410)l/1410 * @​barakplasma made their first contributi[https://github.com/AlaSQL/alasql/pull/1481](https://togithub.com/AlaSQL/alasql/pull/1481)l/1481 * @​Buroni made their first contributi[https://github.com/AlaSQL/alasql/pull/1459](https://togithub.com/AlaSQL/alasql/pull/1459)l/1459 * @​leobia made their first contributi[https://github.com/AlaSQL/alasql/pull/1434](https://togithub.com/AlaSQL/alasql/pull/1434)l/1434 **Full Changelog**: https://github.com/AlaSQL/alasql/compare/v0.6.5...v2.0.1
### [`v2.0.0`](https://togithub.com/alasql/alasql/compare/46db07f424387c25fe9f8a43de09f34865628cc7...04b99c4233d6f39b334c9d8144f9b1d09ba41b12) [Compare Source](https://togithub.com/alasql/alasql/compare/46db07f424387c25fe9f8a43de09f34865628cc7...04b99c4233d6f39b334c9d8144f9b1d09ba41b12) ### [`v1.7.4`](https://togithub.com/alasql/alasql/compare/v1.7.3...46db07f424387c25fe9f8a43de09f34865628cc7) [Compare Source](https://togithub.com/alasql/alasql/compare/v1.7.3...46db07f424387c25fe9f8a43de09f34865628cc7)

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.

This PR has been generated by Mend Renovate. View repository job log here.