databases/{,py-}duckdb: update 0.9.2 → 0.10.0

Reported by:	portscout

6 files changed, 103 insertions, 49 deletions

diff --git a/databases/duckdb/Makefile b/databases/duckdb/Makefile
index 4f4af8907571..672b577ece45 100644
--- a/databases/duckdb/Makefile
+++ b/databases/duckdb/Makefile
@@ -1,7 +1,6 @@
 PORTNAME=	duckdb
 DISTVERSIONPREFIX=	v
-DISTVERSION=	0.9.2
-PORTREVISION=	1
+DISTVERSION=	0.10.0
 CATEGORIES=	databases
 
 MAINTAINER=	yuri@FreeBSD.org
@@ -13,11 +12,11 @@ LICENSE_FILE=	${WRKSRC}/LICENSE
 
 USES=		cmake:testing compiler:c++11-lang ssl
 USE_GITHUB=	yes
-GH_TUPLE=	duckdb:sqlite_scanner:ef91604:sqlite/extension/sqlite_scanner
+GH_TUPLE=	duckdb:sqlite_scanner:c134346:sqlite/extension/sqlite_scanner
 
 CMAKE_ON=	BUILD_SHARED_LIBS
 CMAKE_OFF=	BUILD_UNITTESTS
-CMAKE_TESTING_ON=	BUILD_UNITTESTS
+CMAKE_TESTING_ON=	BUILD_UNITTESTS # 2 tests fail, see https://github.com/duckdb/duckdb/issues/10652
 CMAKE_TESTING_TARGET=	${ALL_TARGET} # hack: works as empty target
 
 BINARY_ALIAS=	git=false
@@ -25,7 +24,7 @@ BINARY_ALIAS=	git=false
 OPTIONS_DEFINE=			TPCE
 OPTIONS_DEFAULT=		TPCE
 OPTIONS_GROUP=			EXTENSIONS
-OPTIONS_GROUP_EXTENSIONS=	AUTOCOMPLETE EXCEL FTS HTTPFS ICU INET JEMALLOC JSON PARQUET SQLSMITH TPCDS TPCH VISUALIZER \
+OPTIONS_GROUP_EXTENSIONS=	AUTOCOMPLETE EXCEL FTS HTTPFS ICU INET JEMALLOC JSON PARQUET SQLSMITH TPCDS TPCH \
 				SQLITE_SCANNER
 
 EXTENSIONS_DESC=		Extensions:
diff --git a/databases/duckdb/distinfo b/databases/duckdb/distinfo
index aac9b3d196fd..044c34d1832c 100644
--- a/databases/duckdb/distinfo
+++ b/databases/duckdb/distinfo
@@ -1,5 +1,5 @@
-TIMESTAMP = 1700111325
-SHA256 (duckdb-duckdb-v0.9.2_GH0.tar.gz) = afff7bd925a98dc2af4039b8ab2159b0705cbf5e0ee05d97f7bb8dce5f880dc2
-SIZE (duckdb-duckdb-v0.9.2_GH0.tar.gz) = 75296956
-SHA256 (duckdb-sqlite_scanner-ef91604_GH0.tar.gz) = 935698a7fde1ec5b5dd94dfd0e02e89a331ca732f6c07add76307839382491cc
-SIZE (duckdb-sqlite_scanner-ef91604_GH0.tar.gz) = 4648835
+TIMESTAMP = 1707894531
+SHA256 (duckdb-duckdb-v0.10.0_GH0.tar.gz) = 5a925b8607d00a97c1a3ffe6df05c0a62a4df063abd022ada82ac1e917792013
+SIZE (duckdb-duckdb-v0.10.0_GH0.tar.gz) = 79037968
+SHA256 (duckdb-sqlite_scanner-c134346_GH0.tar.gz) = 118ab8cb9fcc4e08eee661d2a146ed21c939e30b64123729fbdc90adbd2214f0
+SIZE (duckdb-sqlite_scanner-c134346_GH0.tar.gz) = 4646975
diff --git a/databases/duckdb/pkg-plist b/databases/duckdb/pkg-plist
index b086363fb7ee..2ec80afdddd3 100644
--- a/databases/duckdb/pkg-plist
+++ b/databases/duckdb/pkg-plist
@@ -7,6 +7,9 @@ include/duckdb/catalog/catalog_entry/aggregate_function_catalog_entry.hpp
 include/duckdb/catalog/catalog_entry/collate_catalog_entry.hpp
 include/duckdb/catalog/catalog_entry/column_dependency_manager.hpp
 include/duckdb/catalog/catalog_entry/copy_function_catalog_entry.hpp
+include/duckdb/catalog/catalog_entry/dependency/dependency_dependent_entry.hpp
+include/duckdb/catalog/catalog_entry/dependency/dependency_entry.hpp
+include/duckdb/catalog/catalog_entry/dependency/dependency_subject_entry.hpp
 include/duckdb/catalog/catalog_entry/duck_index_entry.hpp
 include/duckdb/catalog/catalog_entry/duck_schema_entry.hpp
 include/duckdb/catalog/catalog_entry/duck_table_entry.hpp
@@ -36,10 +39,10 @@ include/duckdb/catalog/default/default_schemas.hpp
 include/duckdb/catalog/default/default_types.hpp
 include/duckdb/catalog/default/default_views.hpp
 include/duckdb/catalog/dependency.hpp
+include/duckdb/catalog/dependency_catalog_set.hpp
 include/duckdb/catalog/dependency_list.hpp
 include/duckdb/catalog/dependency_manager.hpp
 include/duckdb/catalog/duck_catalog.hpp
-include/duckdb/catalog/mapping_value.hpp
 include/duckdb/catalog/similar_catalog_entry.hpp
 include/duckdb/catalog/standard_entry.hpp
 include/duckdb/common/adbc/adbc-init.hpp
@@ -96,10 +99,12 @@ include/duckdb/common/enums/expression_type.hpp
 include/duckdb/common/enums/file_compression_type.hpp
 include/duckdb/common/enums/file_glob_options.hpp
 include/duckdb/common/enums/filter_propagate_result.hpp
-include/duckdb/common/enums/index_type.hpp
+include/duckdb/common/enums/index_constraint_type.hpp
 include/duckdb/common/enums/join_type.hpp
 include/duckdb/common/enums/joinref_type.hpp
 include/duckdb/common/enums/logical_operator_type.hpp
+include/duckdb/common/enums/memory_tag.hpp
+include/duckdb/common/enums/on_create_conflict.hpp
 include/duckdb/common/enums/on_entry_not_found.hpp
 include/duckdb/common/enums/operator_result_type.hpp
 include/duckdb/common/enums/optimizer_type.hpp
@@ -121,7 +126,15 @@ include/duckdb/common/enums/undo_flags.hpp
 include/duckdb/common/enums/vector_type.hpp
 include/duckdb/common/enums/wal_type.hpp
 include/duckdb/common/enums/window_aggregation_mode.hpp
+include/duckdb/common/error_data.hpp
 include/duckdb/common/exception.hpp
+include/duckdb/common/exception/binder_exception.hpp
+include/duckdb/common/exception/catalog_exception.hpp
+include/duckdb/common/exception/conversion_exception.hpp
+include/duckdb/common/exception/http_exception.hpp
+include/duckdb/common/exception/list.hpp
+include/duckdb/common/exception/parser_exception.hpp
+include/duckdb/common/exception/transaction_exception.hpp
 include/duckdb/common/exception_format_value.hpp
 include/duckdb/common/extra_operator_info.hpp
 include/duckdb/common/extra_type_info.hpp
@@ -160,6 +173,8 @@ include/duckdb/common/operator/comparison_operators.hpp
 include/duckdb/common/operator/constant_operators.hpp
 include/duckdb/common/operator/convert_to_string.hpp
 include/duckdb/common/operator/decimal_cast_operators.hpp
+include/duckdb/common/operator/double_cast_operator.hpp
+include/duckdb/common/operator/integer_cast_operator.hpp
 include/duckdb/common/operator/multiply.hpp
 include/duckdb/common/operator/numeric_binary_operators.hpp
 include/duckdb/common/operator/numeric_cast.hpp
@@ -170,7 +185,6 @@ include/duckdb/common/optional_ptr.hpp
 include/duckdb/common/pair.hpp
 include/duckdb/common/perfect_map_set.hpp
 include/duckdb/common/pipe_file_system.hpp
-include/duckdb/common/preserved_error.hpp
 include/duckdb/common/printer.hpp
 include/duckdb/common/profiler.hpp
 include/duckdb/common/progress_bar/display/terminal_progress_bar_display.hpp
@@ -220,7 +234,6 @@ include/duckdb/common/types/batched_data_collection.hpp
 include/duckdb/common/types/bit.hpp
 include/duckdb/common/types/blob.hpp
 include/duckdb/common/types/cast_helpers.hpp
-include/duckdb/common/types/chunk_collection.hpp
 include/duckdb/common/types/column/column_data_allocator.hpp
 include/duckdb/common/types/column/column_data_collection.hpp
 include/duckdb/common/types/column/column_data_collection_iterators.hpp
@@ -257,6 +270,7 @@ include/duckdb/common/types/string_type.hpp
 include/duckdb/common/types/time.hpp
 include/duckdb/common/types/timestamp.hpp
 include/duckdb/common/types/type_map.hpp
+include/duckdb/common/types/uhugeint.hpp
 include/duckdb/common/types/uuid.hpp
 include/duckdb/common/types/validity_mask.hpp
 include/duckdb/common/types/value.hpp
@@ -264,6 +278,7 @@ include/duckdb/common/types/value_map.hpp
 include/duckdb/common/types/vector.hpp
 include/duckdb/common/types/vector_buffer.hpp
 include/duckdb/common/types/vector_cache.hpp
+include/duckdb/common/uhugeint.hpp
 include/duckdb/common/unicode_bar.hpp
 include/duckdb/common/union_by_name.hpp
 include/duckdb/common/unique_ptr.hpp
@@ -300,6 +315,8 @@ include/duckdb/core_functions/aggregate/regression_functions.hpp
 include/duckdb/core_functions/aggregate/sum_helpers.hpp
 include/duckdb/core_functions/core_functions.hpp
 include/duckdb/core_functions/function_list.hpp
+include/duckdb/core_functions/lambda_functions.hpp
+include/duckdb/core_functions/scalar/array_functions.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
@@ -311,9 +328,11 @@ include/duckdb/core_functions/scalar/map_functions.hpp
 include/duckdb/core_functions/scalar/math_functions.hpp
 include/duckdb/core_functions/scalar/operators_functions.hpp
 include/duckdb/core_functions/scalar/random_functions.hpp
+include/duckdb/core_functions/scalar/secret_functions.hpp
 include/duckdb/core_functions/scalar/string_functions.hpp
 include/duckdb/core_functions/scalar/struct_functions.hpp
 include/duckdb/core_functions/scalar/union_functions.hpp
+include/duckdb/core_functions/to_interval.hpp
 include/duckdb/execution/adaptive_filter.hpp
 include/duckdb/execution/aggregate_hashtable.hpp
 include/duckdb/execution/base_aggregate_hashtable.hpp
@@ -335,7 +354,11 @@ include/duckdb/execution/index/art/prefix.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/index/index_type.hpp
+include/duckdb/execution/index/index_type_set.hpp
+include/duckdb/execution/index/unknown_index.hpp
 include/duckdb/execution/join_hashtable.hpp
+include/duckdb/execution/merge_sort_tree.hpp
 include/duckdb/execution/nested_loop_join.hpp
 include/duckdb/execution/operator/aggregate/aggregate_object.hpp
 include/duckdb/execution/operator/aggregate/distinct_aggregate_data.hpp
@@ -345,8 +368,30 @@ include/duckdb/execution/operator/aggregate/physical_perfecthash_aggregate.hpp
 include/duckdb/execution/operator/aggregate/physical_streaming_window.hpp
 include/duckdb/execution/operator/aggregate/physical_ungrouped_aggregate.hpp
 include/duckdb/execution/operator/aggregate/physical_window.hpp
+include/duckdb/execution/operator/csv_scanner/buffer_manager/csv_buffer.hpp
+include/duckdb/execution/operator/csv_scanner/buffer_manager/csv_buffer_manager.hpp
+include/duckdb/execution/operator/csv_scanner/buffer_manager/csv_file_handle.hpp
+include/duckdb/execution/operator/csv_scanner/options/csv_option.hpp
+include/duckdb/execution/operator/csv_scanner/options/csv_reader_options.hpp
+include/duckdb/execution/operator/csv_scanner/options/state_machine_options.hpp
+include/duckdb/execution/operator/csv_scanner/scanner/base_scanner.hpp
+include/duckdb/execution/operator/csv_scanner/scanner/column_count_scanner.hpp
+include/duckdb/execution/operator/csv_scanner/scanner/scanner_boundary.hpp
+include/duckdb/execution/operator/csv_scanner/scanner/skip_scanner.hpp
+include/duckdb/execution/operator/csv_scanner/scanner/string_value_scanner.hpp
+include/duckdb/execution/operator/csv_scanner/sniffer/csv_sniffer.hpp
+include/duckdb/execution/operator/csv_scanner/sniffer/quote_rules.hpp
+include/duckdb/execution/operator/csv_scanner/state_machine/csv_state.hpp
+include/duckdb/execution/operator/csv_scanner/state_machine/csv_state_machine.hpp
+include/duckdb/execution/operator/csv_scanner/state_machine/csv_state_machine_cache.hpp
+include/duckdb/execution/operator/csv_scanner/table_function/csv_file_scanner.hpp
+include/duckdb/execution/operator/csv_scanner/table_function/global_csv_state.hpp
+include/duckdb/execution/operator/csv_scanner/util/csv_casting.hpp
+include/duckdb/execution/operator/csv_scanner/util/csv_error.hpp
 include/duckdb/execution/operator/filter/physical_filter.hpp
 include/duckdb/execution/operator/helper/physical_batch_collector.hpp
+include/duckdb/execution/operator/helper/physical_buffered_collector.hpp
+include/duckdb/execution/operator/helper/physical_create_secret.hpp
 include/duckdb/execution/operator/helper/physical_execute.hpp
 include/duckdb/execution/operator/helper/physical_explain_analyze.hpp
 include/duckdb/execution/operator/helper/physical_limit.hpp
@@ -372,17 +417,19 @@ include/duckdb/execution/operator/join/physical_cross_product.hpp
 include/duckdb/execution/operator/join/physical_delim_join.hpp
 include/duckdb/execution/operator/join/physical_hash_join.hpp
 include/duckdb/execution/operator/join/physical_iejoin.hpp
-include/duckdb/execution/operator/join/physical_index_join.hpp
 include/duckdb/execution/operator/join/physical_join.hpp
+include/duckdb/execution/operator/join/physical_left_delim_join.hpp
 include/duckdb/execution/operator/join/physical_nested_loop_join.hpp
 include/duckdb/execution/operator/join/physical_piecewise_merge_join.hpp
 include/duckdb/execution/operator/join/physical_positional_join.hpp
 include/duckdb/execution/operator/join/physical_range_join.hpp
+include/duckdb/execution/operator/join/physical_right_delim_join.hpp
 include/duckdb/execution/operator/order/physical_order.hpp
 include/duckdb/execution/operator/order/physical_top_n.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_database.hpp
 include/duckdb/execution/operator/persistent/physical_copy_to_file.hpp
 include/duckdb/execution/operator/persistent/physical_delete.hpp
 include/duckdb/execution/operator/persistent/physical_export.hpp
@@ -393,19 +440,6 @@ 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
@@ -432,6 +466,7 @@ 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/task_error_manager.hpp
 include/duckdb/execution/window_executor.hpp
 include/duckdb/execution/window_segment_tree.hpp
 include/duckdb/function/aggregate/distributive_functions.hpp
@@ -478,6 +513,8 @@ include/duckdb/function/table_macro_function.hpp
 include/duckdb/function/udf_function.hpp
 include/duckdb/main/appender.hpp
 include/duckdb/main/attached_database.hpp
+include/duckdb/main/buffered_data/buffered_data.hpp
+include/duckdb/main/buffered_data/simple_buffered_data.hpp
 include/duckdb/main/capi/capi_internal.hpp
 include/duckdb/main/capi/cast/from_decimal.hpp
 include/duckdb/main/capi/cast/generic.hpp
@@ -488,6 +525,7 @@ 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_context_state.hpp
 include/duckdb/main/client_data.hpp
 include/duckdb/main/client_properties.hpp
 include/duckdb/main/config.hpp
@@ -536,6 +574,9 @@ include/duckdb/main/relation/value_relation.hpp
 include/duckdb/main/relation/view_relation.hpp
 include/duckdb/main/relation/write_csv_relation.hpp
 include/duckdb/main/relation/write_parquet_relation.hpp
+include/duckdb/main/secret/secret.hpp
+include/duckdb/main/secret/secret_manager.hpp
+include/duckdb/main/secret/secret_storage.hpp
 include/duckdb/main/settings.hpp
 include/duckdb/main/stream_query_result.hpp
 include/duckdb/main/table_description.hpp
@@ -632,6 +673,7 @@ include/duckdb/parser/expression/constant_expression.hpp
 include/duckdb/parser/expression/default_expression.hpp
 include/duckdb/parser/expression/function_expression.hpp
 include/duckdb/parser/expression/lambda_expression.hpp
+include/duckdb/parser/expression/lambdaref_expression.hpp
 include/duckdb/parser/expression/list.hpp
 include/duckdb/parser/expression/operator_expression.hpp
 include/duckdb/parser/expression/parameter_expression.hpp
@@ -648,6 +690,8 @@ include/duckdb/parser/parsed_data/alter_scalar_function_info.hpp
 include/duckdb/parser/parsed_data/alter_table_function_info.hpp
 include/duckdb/parser/parsed_data/alter_table_info.hpp
 include/duckdb/parser/parsed_data/attach_info.hpp
+include/duckdb/parser/parsed_data/bound_pragma_info.hpp
+include/duckdb/parser/parsed_data/comment_on_info.hpp
 include/duckdb/parser/parsed_data/copy_info.hpp
 include/duckdb/parser/parsed_data/create_aggregate_function_info.hpp
 include/duckdb/parser/parsed_data/create_collation_info.hpp
@@ -659,6 +703,7 @@ include/duckdb/parser/parsed_data/create_macro_info.hpp
 include/duckdb/parser/parsed_data/create_pragma_function_info.hpp
 include/duckdb/parser/parsed_data/create_scalar_function_info.hpp
 include/duckdb/parser/parsed_data/create_schema_info.hpp
+include/duckdb/parser/parsed_data/create_secret_info.hpp
 include/duckdb/parser/parsed_data/create_sequence_info.hpp
 include/duckdb/parser/parsed_data/create_table_function_info.hpp
 include/duckdb/parser/parsed_data/create_table_info.hpp
@@ -667,6 +712,7 @@ include/duckdb/parser/parsed_data/create_view_info.hpp
 include/duckdb/parser/parsed_data/detach_info.hpp
 include/duckdb/parser/parsed_data/drop_info.hpp
 include/duckdb/parser/parsed_data/exported_table_data.hpp
+include/duckdb/parser/parsed_data/extra_drop_info.hpp
 include/duckdb/parser/parsed_data/load_info.hpp
 include/duckdb/parser/parsed_data/parse_info.hpp
 include/duckdb/parser/parsed_data/pragma_info.hpp
@@ -694,6 +740,7 @@ include/duckdb/parser/sql_statement.hpp
 include/duckdb/parser/statement/alter_statement.hpp
 include/duckdb/parser/statement/attach_statement.hpp
 include/duckdb/parser/statement/call_statement.hpp
+include/duckdb/parser/statement/copy_database_statement.hpp
 include/duckdb/parser/statement/copy_statement.hpp
 include/duckdb/parser/statement/create_statement.hpp
 include/duckdb/parser/statement/delete_statement.hpp
@@ -713,7 +760,6 @@ include/duckdb/parser/statement/prepare_statement.hpp
 include/duckdb/parser/statement/relation_statement.hpp
 include/duckdb/parser/statement/select_statement.hpp
 include/duckdb/parser/statement/set_statement.hpp
-include/duckdb/parser/statement/show_statement.hpp
 include/duckdb/parser/statement/transaction_statement.hpp
 include/duckdb/parser/statement/update_statement.hpp
 include/duckdb/parser/statement/vacuum_statement.hpp
@@ -724,6 +770,7 @@ include/duckdb/parser/tableref/expressionlistref.hpp
 include/duckdb/parser/tableref/joinref.hpp
 include/duckdb/parser/tableref/list.hpp
 include/duckdb/parser/tableref/pivotref.hpp
+include/duckdb/parser/tableref/showref.hpp
 include/duckdb/parser/tableref/subqueryref.hpp
 include/duckdb/parser/tableref/table_function_ref.hpp
 include/duckdb/parser/tokens.hpp
@@ -790,6 +837,7 @@ 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
+include/duckdb/planner/filter/struct_filter.hpp
 include/duckdb/planner/joinside.hpp
 include/duckdb/planner/logical_operator.hpp
 include/duckdb/planner/logical_operator_visitor.hpp
@@ -799,9 +847,11 @@ include/duckdb/planner/operator/logical_aggregate.hpp
 include/duckdb/planner/operator/logical_any_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_database.hpp
 include/duckdb/planner/operator/logical_copy_to_file.hpp
 include/duckdb/planner/operator/logical_create.hpp
 include/duckdb/planner/operator/logical_create_index.hpp
+include/duckdb/planner/operator/logical_create_secret.hpp
 include/duckdb/planner/operator/logical_create_table.hpp
 include/duckdb/planner/operator/logical_cross_product.hpp
 include/duckdb/planner/operator/logical_cteref.hpp
@@ -834,7 +884,6 @@ include/duckdb/planner/operator/logical_reset.hpp
 include/duckdb/planner/operator/logical_sample.hpp
 include/duckdb/planner/operator/logical_set.hpp
 include/duckdb/planner/operator/logical_set_operation.hpp
-include/duckdb/planner/operator/logical_show.hpp
 include/duckdb/planner/operator/logical_simple.hpp
 include/duckdb/planner/operator/logical_top_n.hpp
 include/duckdb/planner/operator/logical_unconditional_join.hpp
@@ -855,6 +904,7 @@ 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/subquery/rewrite_cte_scan.hpp
 include/duckdb/planner/table_binding.hpp
 include/duckdb/planner/table_filter.hpp
 include/duckdb/planner/tableref/bound_basetableref.hpp
@@ -881,6 +931,19 @@ include/duckdb/storage/checkpoint/table_data_reader.hpp
 include/duckdb/storage/checkpoint/table_data_writer.hpp
 include/duckdb/storage/checkpoint/write_overflow_strings_to_disk.hpp
 include/duckdb/storage/checkpoint_manager.hpp
+include/duckdb/storage/compression/alp/algorithm/alp.hpp
+include/duckdb/storage/compression/alp/alp_analyze.hpp
+include/duckdb/storage/compression/alp/alp_compress.hpp
+include/duckdb/storage/compression/alp/alp_constants.hpp
+include/duckdb/storage/compression/alp/alp_fetch.hpp
+include/duckdb/storage/compression/alp/alp_scan.hpp
+include/duckdb/storage/compression/alp/alp_utils.hpp
+include/duckdb/storage/compression/alprd/algorithm/alprd.hpp
+include/duckdb/storage/compression/alprd/alprd_analyze.hpp
+include/duckdb/storage/compression/alprd/alprd_compress.hpp
+include/duckdb/storage/compression/alprd/alprd_constants.hpp
+include/duckdb/storage/compression/alprd/alprd_fetch.hpp
+include/duckdb/storage/compression/alprd/alprd_scan.hpp
 include/duckdb/storage/compression/bitpacking.hpp
 include/duckdb/storage/compression/chimp/algorithm/bit_reader.hpp
 include/duckdb/storage/compression/chimp/algorithm/bit_utils.hpp
@@ -910,6 +973,7 @@ include/duckdb/storage/data_table.hpp
 include/duckdb/storage/database_size.hpp
 include/duckdb/storage/in_memory_block_manager.hpp
 include/duckdb/storage/index.hpp
+include/duckdb/storage/index_storage_info.hpp
 include/duckdb/storage/magic_bytes.hpp
 include/duckdb/storage/metadata/metadata_manager.hpp
 include/duckdb/storage/metadata/metadata_reader.hpp
@@ -920,6 +984,7 @@ include/duckdb/storage/partial_block_manager.hpp
 include/duckdb/storage/segment/uncompressed.hpp
 include/duckdb/storage/single_file_block_manager.hpp
 include/duckdb/storage/standard_buffer_manager.hpp
+include/duckdb/storage/statistics/array_stats.hpp
 include/duckdb/storage/statistics/base_statistics.hpp
 include/duckdb/storage/statistics/column_statistics.hpp
 include/duckdb/storage/statistics/distinct_statistics.hpp
@@ -936,6 +1001,7 @@ include/duckdb/storage/storage_lock.hpp
 include/duckdb/storage/storage_manager.hpp
 include/duckdb/storage/string_uncompressed.hpp
 include/duckdb/storage/table/append_state.hpp
+include/duckdb/storage/table/array_column_data.hpp
 include/duckdb/storage/table/chunk_info.hpp
 include/duckdb/storage/table/column_checkpoint_state.hpp
 include/duckdb/storage/table/column_data.hpp
@@ -961,6 +1027,7 @@ include/duckdb/storage/table/update_segment.hpp
 include/duckdb/storage/table/validity_column_data.hpp
 include/duckdb/storage/table_io_manager.hpp
 include/duckdb/storage/table_storage_info.hpp
+include/duckdb/storage/temporary_memory_manager.hpp
 include/duckdb/storage/write_ahead_log.hpp
 include/duckdb/transaction/append_info.hpp
 include/duckdb/transaction/cleanup_state.hpp
@@ -980,6 +1047,7 @@ include/duckdb/transaction/update_info.hpp
 include/duckdb/verification/copied_statement_verifier.hpp
 include/duckdb/verification/deserialized_statement_verifier.hpp
 include/duckdb/verification/external_statement_verifier.hpp
+include/duckdb/verification/fetch_row_verifier.hpp
 include/duckdb/verification/no_operator_caching_verifier.hpp
 include/duckdb/verification/parsed_statement_verifier.hpp
 include/duckdb/verification/prepared_statement_verifier.hpp
@@ -998,6 +1066,7 @@ lib/libduckdb_mbedtls.a
 lib/libduckdb_miniz.a
 lib/libduckdb_pg_query.a
 lib/libduckdb_re2.a
+lib/libduckdb_skiplistlib.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 9ee3713c4885..5c064638e2f4 100644
--- a/databases/py-duckdb/Makefile
+++ b/databases/py-duckdb/Makefile
@@ -1,5 +1,5 @@
 PORTNAME=	duckdb
-DISTVERSION=	0.9.2
+DISTVERSION=	0.10.0
 CATEGORIES=	databases python
 MASTER_SITES=	PYPI
 PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
@@ -10,8 +10,7 @@ WWW=		https://duckdb.org/
 
 LICENSE=	MIT
 
-BUILD_DEPENDS=	${PYTHON_PKGNAMEPREFIX}setuptools_scm>0:devel/py-setuptools_scm@${PY_FLAVOR} \
-		${PYTHON_PKGNAMEPREFIX}pybind11>=2.6.0:devel/py-pybind11@${PY_FLAVOR} \
+BUILD_DEPENDS=	${PYTHON_PKGNAMEPREFIX}pybind11>=2.6.0:devel/py-pybind11@${PY_FLAVOR} \
 		${PYNUMPY}
 RUN_DEPENDS=	${PYNUMPY} \
 		${PYTHON_PKGNAMEPREFIX}pandas>0:math/py-pandas@${PY_FLAVOR}
diff --git a/databases/py-duckdb/distinfo b/databases/py-duckdb/distinfo
index 2d7c8480fc33..3dbef9847946 100644
--- a/databases/py-duckdb/distinfo
+++ b/databases/py-duckdb/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1700026657
-SHA256 (duckdb-0.9.2.tar.gz) = 3843afeab7c3fc4a4c0b53686a4cc1d9cdbdadcbb468d60fef910355ecafd447
-SIZE (duckdb-0.9.2.tar.gz) = 10653450
+TIMESTAMP = 1707899619
+SHA256 (duckdb-0.10.0.tar.gz) = c02bcc128002aa79e3c9d89b9de25e062d1096a8793bc0d7932317b7977f6845
+SIZE (duckdb-0.10.0.tar.gz) = 11119589
diff --git a/databases/py-duckdb/files/patch-setup.py b/databases/py-duckdb/files/patch-setup.py
deleted file mode 100644
index fe78d6b0b846..000000000000
--- a/databases/py-duckdb/files/patch-setup.py
+++ /dev/null
@@ -1,13 +0,0 @@
-- allow to pass a newer setuptools_scm
-
---- setup.py.orig	2023-11-14 09:44:27 UTC
-+++ setup.py
-@@ -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,
-     tests_require=['google-cloud-storage', 'mypy', 'pytest'],
-     classifiers=[