git: af65e304f4ad - main - databases/{,py-}duckdb: update 0.8.1 → 0.9.2

From: Yuri Victorovich <yuri_at_FreeBSD.org>
Date: Thu, 16 Nov 2023 02:29:02 UTC
The branch main has been updated by yuri:

URL: https://cgit.FreeBSD.org/ports/commit/?id=af65e304f4add50c414b6fda1115d29442f2eb1d

commit af65e304f4add50c414b6fda1115d29442f2eb1d
Author:     Yuri Victorovich <yuri@FreeBSD.org>
AuthorDate: 2023-11-16 02:27:00 +0000
Commit:     Yuri Victorovich <yuri@FreeBSD.org>
CommitDate: 2023-11-16 02:29:00 +0000

    databases/{,py-}duckdb: update 0.8.1 → 0.9.2
    
    Reported by:    portscout
---
 databases/duckdb/Makefile                |   8 ++-
 databases/duckdb/distinfo                |   6 +-
 databases/duckdb/pkg-plist               | 100 +++++++++++++++++++++++--------
 databases/py-duckdb/Makefile             |   2 +-
 databases/py-duckdb/distinfo             |   6 +-
 databases/py-duckdb/files/patch-setup.py |  12 ++--
 6 files changed, 92 insertions(+), 42 deletions(-)

diff --git a/databases/duckdb/Makefile b/databases/duckdb/Makefile
index 98b5b11c45c5..9105f595aa0e 100644
--- a/databases/duckdb/Makefile
+++ b/databases/duckdb/Makefile
@@ -1,6 +1,6 @@
 PORTNAME=	duckdb
 DISTVERSIONPREFIX=	v
-DISTVERSION=	0.8.1
+DISTVERSION=	0.9.2
 CATEGORIES=	databases
 
 MAINTAINER=	yuri@FreeBSD.org
@@ -23,7 +23,7 @@ BINARY_ALIAS=	git=false
 OPTIONS_DEFINE=			TPCE
 OPTIONS_DEFAULT=		TPCE
 OPTIONS_GROUP=			EXTENSIONS
-OPTIONS_GROUP_EXTENSIONS=	EXCEL FTS HTTPFS ICU INET JEMALLOC JSON PARQUET TPCH TPCDS SQLSMITH VISUALIZER
+OPTIONS_GROUP_EXTENSIONS=	AUTOCOMPLETE EXCEL FTS HTTPFS ICU INET JEMALLOC JSON PARQUET SQLSMITH TPCDS TPCH VISUALIZER
 
 EXTENSIONS_DESC=		Extensions:
 
@@ -32,10 +32,12 @@ EXTENSIONS_DESC=		Extensions:
 OPTIONS_DEFAULT+=	${opt}
 .  endif
 ${opt}_DESC=		Build the ${opt} extension
-${opt}_CMAKE_BOOL=	BUILD_${opt}_EXTENSION
+DUCKDB_EXTENSIONS+=	;${opt:tl}
 ${opt}_PLIST_FILES=	lib/lib${opt:tl}_extension.a
 .endfor
 
+CMAKE_ARGS=	-DBUILD_EXTENSIONS="${DUCKDB_EXTENSIONS:tW:S/ //g:S/^;//}"
+
 TPCE_DESC=			Enable building of the TPC-E tool
 TPCE_CMAKE_BOOL=		BUILD_TPCE
 
diff --git a/databases/duckdb/distinfo b/databases/duckdb/distinfo
index 4e424bd31ab1..00ba6c24c23e 100644
--- a/databases/duckdb/distinfo
+++ b/databases/duckdb/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1687019167
-SHA256 (duckdb-duckdb-v0.8.1_GH0.tar.gz) = a0674f7e320dc7ebcf51990d7fc1c0e7f7b2c335c08f5953702b5285e6c30694
-SIZE (duckdb-duckdb-v0.8.1_GH0.tar.gz) = 76181394
+TIMESTAMP = 1700026259
+SHA256 (duckdb-duckdb-v0.9.2_GH0.tar.gz) = afff7bd925a98dc2af4039b8ab2159b0705cbf5e0ee05d97f7bb8dce5f880dc2
+SIZE (duckdb-duckdb-v0.9.2_GH0.tar.gz) = 75296956
diff --git a/databases/duckdb/pkg-plist b/databases/duckdb/pkg-plist
index 2961205b1b18..b086363fb7ee 100644
--- a/databases/duckdb/pkg-plist
+++ b/databases/duckdb/pkg-plist
@@ -44,15 +44,26 @@ include/duckdb/catalog/similar_catalog_entry.hpp
 include/duckdb/catalog/standard_entry.hpp
 include/duckdb/common/adbc/adbc-init.hpp
 include/duckdb/common/adbc/adbc.hpp
+include/duckdb/common/adbc/single_batch_array_stream.hpp
 include/duckdb/common/algorithm.hpp
 include/duckdb/common/allocator.hpp
 include/duckdb/common/array.hpp
+include/duckdb/common/arrow/appender/append_data.hpp
+include/duckdb/common/arrow/appender/bool_data.hpp
+include/duckdb/common/arrow/appender/enum_data.hpp
+include/duckdb/common/arrow/appender/list.hpp
+include/duckdb/common/arrow/appender/list_data.hpp
+include/duckdb/common/arrow/appender/map_data.hpp
+include/duckdb/common/arrow/appender/scalar_data.hpp
+include/duckdb/common/arrow/appender/struct_data.hpp
+include/duckdb/common/arrow/appender/union_data.hpp
+include/duckdb/common/arrow/appender/varchar_data.hpp
 include/duckdb/common/arrow/arrow.hpp
 include/duckdb/common/arrow/arrow_appender.hpp
 include/duckdb/common/arrow/arrow_buffer.hpp
 include/duckdb/common/arrow/arrow_converter.hpp
-include/duckdb/common/arrow/arrow_options.hpp
 include/duckdb/common/arrow/arrow_wrapper.hpp
+include/duckdb/common/arrow/nanoarrow/nanoarrow.hpp
 include/duckdb/common/arrow/result_arrow_wrapper.hpp
 include/duckdb/common/assert.hpp
 include/duckdb/common/atomic.hpp
@@ -61,6 +72,7 @@ include/duckdb/common/bit_utils.hpp
 include/duckdb/common/bitpacking.hpp
 include/duckdb/common/bitset.hpp
 include/duckdb/common/box_renderer.hpp
+include/duckdb/common/bswap.hpp
 include/duckdb/common/case_insensitive_map.hpp
 include/duckdb/common/checksum.hpp
 include/duckdb/common/chrono.hpp
@@ -77,6 +89,7 @@ include/duckdb/common/enums/access_mode.hpp
 include/duckdb/common/enums/aggregate_handling.hpp
 include/duckdb/common/enums/catalog_type.hpp
 include/duckdb/common/enums/compression_type.hpp
+include/duckdb/common/enums/cte_materialize.hpp
 include/duckdb/common/enums/date_part_specifier.hpp
 include/duckdb/common/enums/debug_initialize.hpp
 include/duckdb/common/enums/expression_type.hpp
@@ -110,12 +123,14 @@ include/duckdb/common/enums/wal_type.hpp
 include/duckdb/common/enums/window_aggregation_mode.hpp
 include/duckdb/common/exception.hpp
 include/duckdb/common/exception_format_value.hpp
+include/duckdb/common/extra_operator_info.hpp
+include/duckdb/common/extra_type_info.hpp
 include/duckdb/common/fast_mem.hpp
-include/duckdb/common/field_writer.hpp
 include/duckdb/common/file_buffer.hpp
 include/duckdb/common/file_opener.hpp
 include/duckdb/common/file_system.hpp
 include/duckdb/common/filename_pattern.hpp
+include/duckdb/common/fixed_size_map.hpp
 include/duckdb/common/fsst.hpp
 include/duckdb/common/fstream.hpp
 include/duckdb/common/gzip_file_system.hpp
@@ -135,6 +150,7 @@ include/duckdb/common/multi_file_reader.hpp
 include/duckdb/common/multi_file_reader_options.hpp
 include/duckdb/common/mutex.hpp
 include/duckdb/common/named_parameter_map.hpp
+include/duckdb/common/numeric_utils.hpp
 include/duckdb/common/opener_file_system.hpp
 include/duckdb/common/operator/abs.hpp
 include/duckdb/common/operator/add.hpp
@@ -166,17 +182,20 @@ include/duckdb/common/radix_partitioning.hpp
 include/duckdb/common/random_engine.hpp
 include/duckdb/common/re2_regex.hpp
 include/duckdb/common/reference_map.hpp
+include/duckdb/common/row_operations/row_matcher.hpp
 include/duckdb/common/row_operations/row_operations.hpp
-include/duckdb/common/serializer.hpp
 include/duckdb/common/serializer/binary_deserializer.hpp
 include/duckdb/common/serializer/binary_serializer.hpp
-include/duckdb/common/serializer/buffered_deserializer.hpp
 include/duckdb/common/serializer/buffered_file_reader.hpp
 include/duckdb/common/serializer/buffered_file_writer.hpp
-include/duckdb/common/serializer/buffered_serializer.hpp
-include/duckdb/common/serializer/format_deserializer.hpp
-include/duckdb/common/serializer/format_serializer.hpp
+include/duckdb/common/serializer/deserialization_data.hpp
+include/duckdb/common/serializer/deserializer.hpp
+include/duckdb/common/serializer/encoding_util.hpp
+include/duckdb/common/serializer/memory_stream.hpp
+include/duckdb/common/serializer/read_stream.hpp
 include/duckdb/common/serializer/serialization_traits.hpp
+include/duckdb/common/serializer/serializer.hpp
+include/duckdb/common/serializer/write_stream.hpp
 include/duckdb/common/set.hpp
 include/duckdb/common/shared_ptr.hpp
 include/duckdb/common/sort/comparators.hpp
@@ -185,6 +204,7 @@ include/duckdb/common/sort/partition_state.hpp
 include/duckdb/common/sort/sort.hpp
 include/duckdb/common/sort/sorted_block.hpp
 include/duckdb/common/stack.hpp
+include/duckdb/common/stack_checker.hpp
 include/duckdb/common/string.hpp
 include/duckdb/common/string_map_set.hpp
 include/duckdb/common/string_util.hpp
@@ -273,6 +293,7 @@ include/duckdb/core_functions/aggregate/algebraic_functions.hpp
 include/duckdb/core_functions/aggregate/distributive_functions.hpp
 include/duckdb/core_functions/aggregate/holistic_functions.hpp
 include/duckdb/core_functions/aggregate/nested_functions.hpp
+include/duckdb/core_functions/aggregate/quantile_enum.hpp
 include/duckdb/core_functions/aggregate/regression/regr_count.hpp
 include/duckdb/core_functions/aggregate/regression/regr_slope.hpp
 include/duckdb/core_functions/aggregate/regression_functions.hpp
@@ -282,6 +303,7 @@ include/duckdb/core_functions/function_list.hpp
 include/duckdb/core_functions/scalar/bit_functions.hpp
 include/duckdb/core_functions/scalar/blob_functions.hpp
 include/duckdb/core_functions/scalar/date_functions.hpp
+include/duckdb/core_functions/scalar/debug_functions.hpp
 include/duckdb/core_functions/scalar/enum_functions.hpp
 include/duckdb/core_functions/scalar/generic_functions.hpp
 include/duckdb/core_functions/scalar/list_functions.hpp
@@ -302,18 +324,17 @@ include/duckdb/execution/expression_executor.hpp
 include/duckdb/execution/expression_executor_state.hpp
 include/duckdb/execution/index/art/art.hpp
 include/duckdb/execution/index/art/art_key.hpp
-include/duckdb/execution/index/art/fixed_size_allocator.hpp
 include/duckdb/execution/index/art/iterator.hpp
 include/duckdb/execution/index/art/leaf.hpp
-include/duckdb/execution/index/art/leaf_segment.hpp
 include/duckdb/execution/index/art/node.hpp
 include/duckdb/execution/index/art/node16.hpp
 include/duckdb/execution/index/art/node256.hpp
 include/duckdb/execution/index/art/node4.hpp
 include/duckdb/execution/index/art/node48.hpp
 include/duckdb/execution/index/art/prefix.hpp
-include/duckdb/execution/index/art/prefix_segment.hpp
-include/duckdb/execution/index/art/swizzleable_pointer.hpp
+include/duckdb/execution/index/fixed_size_allocator.hpp
+include/duckdb/execution/index/fixed_size_buffer.hpp
+include/duckdb/execution/index/index_pointer.hpp
 include/duckdb/execution/join_hashtable.hpp
 include/duckdb/execution/nested_loop_join.hpp
 include/duckdb/execution/operator/aggregate/aggregate_object.hpp
@@ -359,13 +380,7 @@ include/duckdb/execution/operator/join/physical_positional_join.hpp
 include/duckdb/execution/operator/join/physical_range_join.hpp
 include/duckdb/execution/operator/order/physical_order.hpp
 include/duckdb/execution/operator/order/physical_top_n.hpp
-include/duckdb/execution/operator/persistent/base_csv_reader.hpp
-include/duckdb/execution/operator/persistent/buffered_csv_reader.hpp
-include/duckdb/execution/operator/persistent/csv_buffer.hpp
-include/duckdb/execution/operator/persistent/csv_file_handle.hpp
-include/duckdb/execution/operator/persistent/csv_line_info.hpp
-include/duckdb/execution/operator/persistent/csv_reader_options.hpp
-include/duckdb/execution/operator/persistent/parallel_csv_reader.hpp
+include/duckdb/execution/operator/persistent/csv_rejects_table.hpp
 include/duckdb/execution/operator/persistent/physical_batch_copy_to_file.hpp
 include/duckdb/execution/operator/persistent/physical_batch_insert.hpp
 include/duckdb/execution/operator/persistent/physical_copy_to_file.hpp
@@ -378,6 +393,19 @@ include/duckdb/execution/operator/projection/physical_pivot.hpp
 include/duckdb/execution/operator/projection/physical_projection.hpp
 include/duckdb/execution/operator/projection/physical_tableinout_function.hpp
 include/duckdb/execution/operator/projection/physical_unnest.hpp
+include/duckdb/execution/operator/scan/csv/base_csv_reader.hpp
+include/duckdb/execution/operator/scan/csv/buffered_csv_reader.hpp
+include/duckdb/execution/operator/scan/csv/csv_buffer.hpp
+include/duckdb/execution/operator/scan/csv/csv_buffer_manager.hpp
+include/duckdb/execution/operator/scan/csv/csv_file_handle.hpp
+include/duckdb/execution/operator/scan/csv/csv_line_info.hpp
+include/duckdb/execution/operator/scan/csv/csv_reader_options.hpp
+include/duckdb/execution/operator/scan/csv/csv_sniffer.hpp
+include/duckdb/execution/operator/scan/csv/csv_state.hpp
+include/duckdb/execution/operator/scan/csv/csv_state_machine.hpp
+include/duckdb/execution/operator/scan/csv/csv_state_machine_cache.hpp
+include/duckdb/execution/operator/scan/csv/parallel_csv_reader.hpp
+include/duckdb/execution/operator/scan/csv/quote_rules.hpp
 include/duckdb/execution/operator/scan/physical_column_data_scan.hpp
 include/duckdb/execution/operator/scan/physical_dummy_scan.hpp
 include/duckdb/execution/operator/scan/physical_empty_result.hpp
@@ -386,8 +414,8 @@ include/duckdb/execution/operator/scan/physical_positional_scan.hpp
 include/duckdb/execution/operator/scan/physical_table_scan.hpp
 include/duckdb/execution/operator/schema/physical_alter.hpp
 include/duckdb/execution/operator/schema/physical_attach.hpp
+include/duckdb/execution/operator/schema/physical_create_art_index.hpp
 include/duckdb/execution/operator/schema/physical_create_function.hpp
-include/duckdb/execution/operator/schema/physical_create_index.hpp
 include/duckdb/execution/operator/schema/physical_create_schema.hpp
 include/duckdb/execution/operator/schema/physical_create_sequence.hpp
 include/duckdb/execution/operator/schema/physical_create_table.hpp
@@ -395,15 +423,16 @@ include/duckdb/execution/operator/schema/physical_create_type.hpp
 include/duckdb/execution/operator/schema/physical_create_view.hpp
 include/duckdb/execution/operator/schema/physical_detach.hpp
 include/duckdb/execution/operator/schema/physical_drop.hpp
+include/duckdb/execution/operator/set/physical_cte.hpp
 include/duckdb/execution/operator/set/physical_recursive_cte.hpp
 include/duckdb/execution/operator/set/physical_union.hpp
-include/duckdb/execution/partitionable_hashtable.hpp
 include/duckdb/execution/perfect_aggregate_hashtable.hpp
 include/duckdb/execution/physical_operator.hpp
 include/duckdb/execution/physical_operator_states.hpp
 include/duckdb/execution/physical_plan_generator.hpp
 include/duckdb/execution/radix_partitioned_hashtable.hpp
 include/duckdb/execution/reservoir_sample.hpp
+include/duckdb/execution/window_executor.hpp
 include/duckdb/execution/window_segment_tree.hpp
 include/duckdb/function/aggregate/distributive_functions.hpp
 include/duckdb/function/aggregate_function.hpp
@@ -425,6 +454,7 @@ include/duckdb/function/macro_function.hpp
 include/duckdb/function/pragma/pragma_functions.hpp
 include/duckdb/function/pragma_function.hpp
 include/duckdb/function/replacement_scan.hpp
+include/duckdb/function/scalar/compressed_materialization_functions.hpp
 include/duckdb/function/scalar/generic_functions.hpp
 include/duckdb/function/scalar/list/contains_or_position.hpp
 include/duckdb/function/scalar/nested_functions.hpp
@@ -436,6 +466,7 @@ include/duckdb/function/scalar/string_functions.hpp
 include/duckdb/function/scalar_function.hpp
 include/duckdb/function/scalar_macro_function.hpp
 include/duckdb/function/table/arrow.hpp
+include/duckdb/function/table/arrow/arrow_duck_schema.hpp
 include/duckdb/function/table/list.hpp
 include/duckdb/function/table/range.hpp
 include/duckdb/function/table/read_csv.hpp
@@ -452,10 +483,13 @@ include/duckdb/main/capi/cast/from_decimal.hpp
 include/duckdb/main/capi/cast/generic.hpp
 include/duckdb/main/capi/cast/to_decimal.hpp
 include/duckdb/main/capi/cast/utils.hpp
+include/duckdb/main/chunk_scan_state.hpp
+include/duckdb/main/chunk_scan_state/query_result.hpp
 include/duckdb/main/client_config.hpp
 include/duckdb/main/client_context.hpp
 include/duckdb/main/client_context_file_opener.hpp
 include/duckdb/main/client_data.hpp
+include/duckdb/main/client_properties.hpp
 include/duckdb/main/config.hpp
 include/duckdb/main/connection.hpp
 include/duckdb/main/connection_manager.hpp
@@ -465,6 +499,7 @@ include/duckdb/main/database_path_and_type.hpp
 include/duckdb/main/db_instance_cache.hpp
 include/duckdb/main/error_manager.hpp
 include/duckdb/main/extension.hpp
+include/duckdb/main/extension/generated_extension_loader.hpp
 include/duckdb/main/extension_entries.hpp
 include/duckdb/main/extension_helper.hpp
 include/duckdb/main/extension_util.hpp
@@ -505,8 +540,10 @@ include/duckdb/main/settings.hpp
 include/duckdb/main/stream_query_result.hpp
 include/duckdb/main/table_description.hpp
 include/duckdb/main/valid_checker.hpp
+include/duckdb/optimizer/column_binding_replacer.hpp
 include/duckdb/optimizer/column_lifetime_optimizer.hpp
 include/duckdb/optimizer/common_aggregate_optimizer.hpp
+include/duckdb/optimizer/compressed_materialization.hpp
 include/duckdb/optimizer/cse_optimizer.hpp
 include/duckdb/optimizer/deliminator.hpp
 include/duckdb/optimizer/expression_heuristics.hpp
@@ -516,11 +553,16 @@ include/duckdb/optimizer/filter_pullup.hpp
 include/duckdb/optimizer/filter_pushdown.hpp
 include/duckdb/optimizer/in_clause_rewriter.hpp
 include/duckdb/optimizer/join_order/cardinality_estimator.hpp
+include/duckdb/optimizer/join_order/cost_model.hpp
 include/duckdb/optimizer/join_order/estimated_properties.hpp
 include/duckdb/optimizer/join_order/join_node.hpp
 include/duckdb/optimizer/join_order/join_order_optimizer.hpp
 include/duckdb/optimizer/join_order/join_relation.hpp
+include/duckdb/optimizer/join_order/plan_enumerator.hpp
 include/duckdb/optimizer/join_order/query_graph.hpp
+include/duckdb/optimizer/join_order/query_graph_manager.hpp
+include/duckdb/optimizer/join_order/relation_manager.hpp
+include/duckdb/optimizer/join_order/relation_statistics_helper.hpp
 include/duckdb/optimizer/matcher/expression_matcher.hpp
 include/duckdb/optimizer/matcher/expression_type_matcher.hpp
 include/duckdb/optimizer/matcher/function_matcher.hpp
@@ -531,6 +573,7 @@ include/duckdb/optimizer/matcher/type_matcher_id.hpp
 include/duckdb/optimizer/optimizer.hpp
 include/duckdb/optimizer/optimizer_extension.hpp
 include/duckdb/optimizer/regex_range_filter.hpp
+include/duckdb/optimizer/remove_duplicate_groups.hpp
 include/duckdb/optimizer/remove_unused_columns.hpp
 include/duckdb/optimizer/rule.hpp
 include/duckdb/optimizer/rule/arithmetic_simplification.hpp
@@ -640,6 +683,7 @@ include/duckdb/parser/qualified_name.hpp
 include/duckdb/parser/qualified_name_set.hpp
 include/duckdb/parser/query_error_context.hpp
 include/duckdb/parser/query_node.hpp
+include/duckdb/parser/query_node/cte_node.hpp
 include/duckdb/parser/query_node/list.hpp
 include/duckdb/parser/query_node/recursive_cte_node.hpp
 include/duckdb/parser/query_node/select_node.hpp
@@ -742,6 +786,7 @@ include/duckdb/planner/expression_binder/table_function_binder.hpp
 include/duckdb/planner/expression_binder/update_binder.hpp
 include/duckdb/planner/expression_binder/where_binder.hpp
 include/duckdb/planner/expression_iterator.hpp
+include/duckdb/planner/extension_callback.hpp
 include/duckdb/planner/filter/conjunction_filter.hpp
 include/duckdb/planner/filter/constant_filter.hpp
 include/duckdb/planner/filter/null_filter.hpp
@@ -752,7 +797,6 @@ include/duckdb/planner/logical_tokens.hpp
 include/duckdb/planner/operator/list.hpp
 include/duckdb/planner/operator/logical_aggregate.hpp
 include/duckdb/planner/operator/logical_any_join.hpp
-include/duckdb/planner/operator/logical_asof_join.hpp
 include/duckdb/planner/operator/logical_column_data_get.hpp
 include/duckdb/planner/operator/logical_comparison_join.hpp
 include/duckdb/planner/operator/logical_copy_to_file.hpp
@@ -763,7 +807,7 @@ include/duckdb/planner/operator/logical_cross_product.hpp
 include/duckdb/planner/operator/logical_cteref.hpp
 include/duckdb/planner/operator/logical_delete.hpp
 include/duckdb/planner/operator/logical_delim_get.hpp
-include/duckdb/planner/operator/logical_delim_join.hpp
+include/duckdb/planner/operator/logical_dependent_join.hpp
 include/duckdb/planner/operator/logical_distinct.hpp
 include/duckdb/planner/operator/logical_dummy_scan.hpp
 include/duckdb/planner/operator/logical_empty_result.hpp
@@ -778,6 +822,7 @@ include/duckdb/planner/operator/logical_insert.hpp
 include/duckdb/planner/operator/logical_join.hpp
 include/duckdb/planner/operator/logical_limit.hpp
 include/duckdb/planner/operator/logical_limit_percent.hpp
+include/duckdb/planner/operator/logical_materialized_cte.hpp
 include/duckdb/planner/operator/logical_order.hpp
 include/duckdb/planner/operator/logical_pivot.hpp
 include/duckdb/planner/operator/logical_positional_join.hpp
@@ -799,15 +844,16 @@ include/duckdb/planner/operator/logical_window.hpp
 include/duckdb/planner/operator_extension.hpp
 include/duckdb/planner/parsed_data/bound_create_function_info.hpp
 include/duckdb/planner/parsed_data/bound_create_table_info.hpp
-include/duckdb/planner/plan_serialization.hpp
 include/duckdb/planner/planner.hpp
 include/duckdb/planner/pragma_handler.hpp
+include/duckdb/planner/query_node/bound_cte_node.hpp
 include/duckdb/planner/query_node/bound_recursive_cte_node.hpp
 include/duckdb/planner/query_node/bound_select_node.hpp
 include/duckdb/planner/query_node/bound_set_operation_node.hpp
 include/duckdb/planner/query_node/list.hpp
 include/duckdb/planner/subquery/flatten_dependent_join.hpp
 include/duckdb/planner/subquery/has_correlated_expressions.hpp
+include/duckdb/planner/subquery/recursive_dependent_join_planner.hpp
 include/duckdb/planner/subquery/rewrite_correlated_expressions.hpp
 include/duckdb/planner/table_binding.hpp
 include/duckdb/planner/table_filter.hpp
@@ -865,8 +911,9 @@ include/duckdb/storage/database_size.hpp
 include/duckdb/storage/in_memory_block_manager.hpp
 include/duckdb/storage/index.hpp
 include/duckdb/storage/magic_bytes.hpp
-include/duckdb/storage/meta_block_reader.hpp
-include/duckdb/storage/meta_block_writer.hpp
+include/duckdb/storage/metadata/metadata_manager.hpp
+include/duckdb/storage/metadata/metadata_reader.hpp
+include/duckdb/storage/metadata/metadata_writer.hpp
 include/duckdb/storage/object_cache.hpp
 include/duckdb/storage/optimistic_data_writer.hpp
 include/duckdb/storage/partial_block_manager.hpp
@@ -901,6 +948,7 @@ include/duckdb/storage/table/persistent_table_data.hpp
 include/duckdb/storage/table/row_group.hpp
 include/duckdb/storage/table/row_group_collection.hpp
 include/duckdb/storage/table/row_group_segment_tree.hpp
+include/duckdb/storage/table/row_version_manager.hpp
 include/duckdb/storage/table/scan_state.hpp
 include/duckdb/storage/table/segment_base.hpp
 include/duckdb/storage/table/segment_lock.hpp
@@ -931,7 +979,6 @@ include/duckdb/transaction/undo_buffer.hpp
 include/duckdb/transaction/update_info.hpp
 include/duckdb/verification/copied_statement_verifier.hpp
 include/duckdb/verification/deserialized_statement_verifier.hpp
-include/duckdb/verification/deserialized_statement_verifier_v2.hpp
 include/duckdb/verification/external_statement_verifier.hpp
 include/duckdb/verification/no_operator_caching_verifier.hpp
 include/duckdb/verification/parsed_statement_verifier.hpp
@@ -953,3 +1000,4 @@ lib/libduckdb_pg_query.a
 lib/libduckdb_re2.a
 lib/libduckdb_static.a
 lib/libduckdb_utf8proc.a
+@dir include/duckdb/storage/serialization
diff --git a/databases/py-duckdb/Makefile b/databases/py-duckdb/Makefile
index 9864cbe4c530..a770f50563fc 100644
--- a/databases/py-duckdb/Makefile
+++ b/databases/py-duckdb/Makefile
@@ -1,5 +1,5 @@
 PORTNAME=	duckdb
-DISTVERSION=	0.8.1
+DISTVERSION=	0.9.2
 CATEGORIES=	databases python
 MASTER_SITES=	PYPI
 PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
diff --git a/databases/py-duckdb/distinfo b/databases/py-duckdb/distinfo
index 54f733850590..2d7c8480fc33 100644
--- a/databases/py-duckdb/distinfo
+++ b/databases/py-duckdb/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1687025388
-SHA256 (duckdb-0.8.1.tar.gz) = a54d37f4abc2afc4f92314aaa56ecf215a411f40af4bffe1e86bd25e62aceee9
-SIZE (duckdb-0.8.1.tar.gz) = 10421102
+TIMESTAMP = 1700026657
+SHA256 (duckdb-0.9.2.tar.gz) = 3843afeab7c3fc4a4c0b53686a4cc1d9cdbdadcbb468d60fef910355ecafd447
+SIZE (duckdb-0.9.2.tar.gz) = 10653450
diff --git a/databases/py-duckdb/files/patch-setup.py b/databases/py-duckdb/files/patch-setup.py
index 0551b1005487..fe78d6b0b846 100644
--- a/databases/py-duckdb/files/patch-setup.py
+++ b/databases/py-duckdb/files/patch-setup.py
@@ -1,13 +1,13 @@
 - allow to pass a newer setuptools_scm
 
---- setup.py.orig	2023-11-03 21:27:16 UTC
+--- setup.py.orig	2023-11-14 09:44:27 UTC
 +++ setup.py
-@@ -290,7 +290,7 @@ setup(
-         'duckdb-stubs'
-     ],
+@@ -349,7 +349,7 @@ setup(
+     packages=packages,
      include_package_data=True,
+     python_requires='>=3.7.0',
 -    setup_requires=setup_requires + ["setuptools_scm<7.0.0", 'pybind11>=2.6.0'],
 +    setup_requires=setup_requires + ["setuptools_scm", 'pybind11>=2.6.0'],
-     use_scm_version = setuptools_scm_conf,
+     use_scm_version=setuptools_scm_conf,
      tests_require=['google-cloud-storage', 'mypy', 'pytest'],
-     classifiers = [
+     classifiers=[