This release of DuckDB is named "Nivis" after the sadly non-existent Snow Duck (Anas Nivis) that is known for its stability.

Please also refer to the announcement blog post: https://duckdb.org/2024/06/03/announcing-duckdb-100

What's Changed

• Fix move constants optimization by @gitccl in https://github.com/duckdb/duckdb/pull/12189
• FALLOC_FL_PUNCH_HOLE requires GLIBC 2.18 or above - check for this using an #ifdef by @Mytherin in https://github.com/duckdb/duckdb/pull/12193
• Fix cmake install for shared_ptr headers by @carlopi in https://github.com/duckdb/duckdb/pull/12194
• Fix minor warnings by @carlopi in https://github.com/duckdb/duckdb/pull/12195
• Install .ipp files in addition to the usual .hpp files by @smonkewitz in https://github.com/duckdb/duckdb/pull/12198
• Set a default value to the connection param in stubs by @tm-drtina in https://github.com/duckdb/duckdb/pull/12207
• Fix #12190: add SYSTEM to set of reserved database names by @Mytherin in https://github.com/duckdb/duckdb/pull/12206
• Add enable_view_dependencies which defaults to false by @Tishj in https://github.com/duckdb/duckdb/pull/12209
• [Python] Fix replacement scans incorrectly finding duckdb connection method objects by @Tishj in https://github.com/duckdb/duckdb/pull/12208
• [CI] Diff against the right remote + branch in Regressions.yml - Regression Test new micro benchmark by @Tishj in https://github.com/duckdb/duckdb/pull/12106
• [Python] Fix bug where enable_external_access was not being respected by the replacement scan by @Tishj in https://github.com/duckdb/duckdb/pull/12224
• Remove outdated CI for extensions, check duckdb/extension-ci-tools by @carlopi in https://github.com/duckdb/duckdb/pull/12229
• Python: Avoid packaging for both 3.7 on OSX and MacOS 11 by @carlopi in https://github.com/duckdb/duckdb/pull/12236
• Issue #12215: AsOf Predicate Pushdown by @hawkfish in https://github.com/duckdb/duckdb/pull/12238
• [DependencyManager] Don't block ADD COLUMN statements if there are dependencies. by @Tishj in https://github.com/duckdb/duckdb/pull/12226
• [Python] Add check for 'params' to table_function by @Tishj in https://github.com/duckdb/duckdb/pull/12233
• Extension installing/updateing fixes by @samansmink in https://github.com/duckdb/duckdb/pull/12221
• Move excel extension out of tree by @carlopi in https://github.com/duckdb/duckdb/pull/12123
• Fix #12225: revert OVERWRITE_OR_IGNORE to previous behavior, move new behavior to OVERWRITE flag by @Mytherin in https://github.com/duckdb/duckdb/pull/12240
• Fix warning on unannotated fallthrough by @carlopi in https://github.com/duckdb/duckdb/pull/12244
• Fixup staged uploads /3 by @carlopi in https://github.com/duckdb/duckdb/pull/12245
• [Python] fix build when BUILD_HTTPFS set by @paparodeo in https://github.com/duckdb/duckdb/pull/12223
• Use --always option of git describe for extension tags. by @carlopi in https://github.com/duckdb/duckdb/pull/12253
• [Docs] Fix up examples/python/duckdb-python.py by @Tishj in https://github.com/duckdb/duckdb/pull/12255
• [Fix] Skip lazy WAL creation test for alternative verification by @taniabogatsch in https://github.com/duckdb/duckdb/pull/12258
• add missing virtual destructor by @samansmink in https://github.com/duckdb/duckdb/pull/12266
• Add storage callbacks for checkpoint start and end by @bleskes in https://github.com/duckdb/duckdb/pull/12260
• Do not prefix error messages with an unknown type by @bleskes in https://github.com/duckdb/duckdb/pull/12265
• Fix minor duckdb_extensions table function bug by @samansmink in https://github.com/duckdb/duckdb/pull/12269
• C API: Adding deprecation and move notices to duckdb.h and a test case by @hannes in https://github.com/duckdb/duckdb/pull/12259
• Issue #12252: APPROX_QUANTILE Array Argument by @hawkfish in https://github.com/duckdb/duckdb/pull/12271
• Turn InternalException into NotImplementedException in COPY FROM DATABASE by @Mytherin in https://github.com/duckdb/duckdb/pull/12264
• Add descriptions for vss and delta extensions by @carlopi in https://github.com/duckdb/duckdb/pull/12267
• [C-API] Properly handle exceptions caused by name collisions in duckdb_register_table_function by @Tishj in https://github.com/duckdb/duckdb/pull/12257
• Fix for multifilereader extra_columns feature by @samansmink in https://github.com/duckdb/duckdb/pull/12281
• Add enable_macro_dependencies which defaults to false by @Mytherin in https://github.com/duckdb/duckdb/pull/12291

Full Changelog: https://github.com/duckdb/duckdb/compare/v0.10.3...v1.0.0