DuckDB 1.0.0 "Nivis"

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

Full Changelog: v0.10.3...v1.0.0