Bump duckdb from 0.8.1 to 0.9.0

[dependabot[bot]]

Bumps duckdb from 0.8.1 to 0.9.0.

Release notes

Sourced from duckdb's releases.

0.9.0 Preview Release "Undulata"

This preview release of DuckDB is named "Undulata" after the aptly named Yellow-billed duck native to Africa.

Note: Again, this release introduces a backwards-incompatible change to the on-disk storage format. We suggest you use the EXPORT DATABASE command with the old version followed by IMPORT DATABASE with the new version to migrate your data. See the documentation for details.

What's Changed

• [Dev] Merge master into feature by @​Tishj in duckdb/duckdb#7535
• Issue #7563: make_timestamptz by @​hawkfish in duckdb/duckdb#7597
• Add support for nested laterals by @​arhamchopra in duckdb/duckdb#7528
• Issue #7563: epoch_us(temporal) by @​hawkfish in duckdb/duckdb#7629
• Fix lingering clang-tidy issues by @​Mytherin in duckdb/duckdb#7670
• Add list_intersect, list_has_any, and list_has_all by @​maiadegraaf in duckdb/duckdb#7518
• Issue #7563: epoch_xs(temporal) by @​hawkfish in duckdb/duckdb#7648
• Pivot - dynamically switch between using filtered aggregates or the new pivot operator by @​Mytherin in duckdb/duckdb#7688
• Add wildcard to JSON Path by @​lnkuiper in duckdb/duckdb#7624
• [Dev] Add optional build flag to disable assertions in debug mode by @​Tishj in duckdb/duckdb#7618
• [DEV]: ICU C Casts by @​hawkfish in duckdb/duckdb#7715
• List_resize by @​maiadegraaf in duckdb/duckdb#7401
• Issue #7187: AsOf Join Performance by @​hawkfish in duckdb/duckdb#7607
• Some minor CI changes by @​samansmink in duckdb/duckdb#7763
• Binder coverage by @​hawkfish in duckdb/duckdb#7791
• Vacuum Completely Deleted Row Groups by @​Mytherin in duckdb/duckdb#7794
• Issue #7187: AsOf Coverage by @​hawkfish in duckdb/duckdb#7774
• Implement FIELD_IDS for parquet writes by @​lnkuiper in duckdb/duckdb#7696
• Optimize Regexp_matches to LIKE statements when possible by @​Tmonster in duckdb/duckdb#7264
• Jemalloc configuration, more buffer allocator, and remove redundant string copying in parquet dictionary by @​lnkuiper in duckdb/duckdb#7697
• Truncate Database File on Checkpoint by @​Mytherin in duckdb/duckdb#7824
• LEFT JOIN ON TRUE support by @​taniabogatsch in duckdb/duckdb#7821
• Issue #7809: Segment Tree Performance by @​hawkfish in duckdb/duckdb#7831
• C Data Interface: duckdb_arrow_scan and duckdb_arrow_array_scan by @​angadn in duckdb/duckdb#7570
• Update Julia to 0.8.1 by @​Mytherin in duckdb/duckdb#7932
• Add conn.interrupt() to DuckDB python API by @​henrinikku in duckdb/duckdb#7895
• renaming part of extension build refactor PR by @​samansmink in duckdb/duckdb#7926
• fix swapped x/y regression parameters by @​MartinNowak in duckdb/duckdb#7855
• [Docs] Aggregate function README.md by @​hawkfish in duckdb/duckdb#7881
• PhysicalPiecewiseMergeJoin improvement by @​xuke-hat in duckdb/duckdb#7832
• Initial set of commits to add support for zOS (an IBM mainframe operating system) by @​v1gnesh in duckdb/duckdb#7805
• test(nodejs): add test_all_types.test.ts by @​Mause in duckdb/duckdb#7740
• Issue #7879: Missing JDBC TIMESTAMP_TZ by @​hawkfish in duckdb/duckdb#7922
• Attempt to fix CI on Windows 32 and Python on Windows by @​carlopi in duckdb/duckdb#7961
• Fix 7947 by @​lnkuiper in duckdb/duckdb#7963
• test: patch test_7652 to skip on pyarrow<11 by @​gforsyth in duckdb/duckdb#7966
• NodeJS: Add columns() method to get type info from prepared statement by @​Maxxen in duckdb/duckdb#7948
• Fix: Don't free arrow children explicitly by @​Maxxen in duckdb/duckdb#7917
• CSV Rejects table by @​Maxxen in duckdb/duckdb#7681
• Issue #7809: Segment Tree Performance by @​hawkfish in duckdb/duckdb#7891
• Add tpch benchmark run exclusively on parquet files by @​Tmonster in duckdb/duckdb#7519
• Bidirectional check storage + minor CI fixes by @​carlopi in duckdb/duckdb#7955
• [Swift] fix #7985 by @​tcldr in duckdb/duckdb#7993
• Move @​samansmink's extension_header_rename.patch by @​carlopi in duckdb/duckdb#8001

... (truncated)

Commits

• 946c60a Python: skip test depending on garbage collector behaviour
• 4923736 Merge pull request #9074 from lnkuiper/close_json_file
• 2548301 Fix use of os.environ dictionary in setup.py script
• 31cc0ff don't close files if piped
• 8c9a87f Skip sporadic failures
• ad030db Merge pull request #9073 from Mause/unrequire-filesystem
• c7a4ca8 filesystem module shouldn't be required
• 995fd98 Here as well
• 26a24c4 Set verbose flag in cibw.toml instead
• 2e77e2e Merge pull request #9068 from Mytherin/adbcdrivermanagerpin
• Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)