5 files changed, 123 insertions, 46 deletions

diff --git a/databases/duckdb/Makefile b/databases/duckdb/Makefile
index 14662422cbbf..7a64b81dbf53 100644
--- a/databases/duckdb/Makefile
+++ b/databases/duckdb/Makefile
@@ -1,6 +1,6 @@
 PORTNAME=	duckdb
 DISTVERSIONPREFIX=	v
-DISTVERSION=	0.7.1
+DISTVERSION=	0.8.0
 CATEGORIES=	databases
 
 MAINTAINER=	yuri@FreeBSD.org
diff --git a/databases/duckdb/distinfo b/databases/duckdb/distinfo
index 2404887aff51..7b04412c83af 100644
--- a/databases/duckdb/distinfo
+++ b/databases/duckdb/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1677519558
-SHA256 (duckdb-duckdb-v0.7.1_GH0.tar.gz) = 67f840f861e5ffbe137d65a8543642d016f900b89dd035492d562ad11acf0e1e
-SIZE (duckdb-duckdb-v0.7.1_GH0.tar.gz) = 74701865
+TIMESTAMP = 1684476380
+SHA256 (duckdb-duckdb-v0.8.0_GH0.tar.gz) = df3b8e0b72bce38914f0fb1cd02235d8b616df9209beb14beb06bfbcaaf2e97f
+SIZE (duckdb-duckdb-v0.8.0_GH0.tar.gz) = 75235210
diff --git a/databases/duckdb/pkg-plist b/databases/duckdb/pkg-plist
index bfa9b79c5d8d..abe4c2c5f8ff 100644
--- a/databases/duckdb/pkg-plist
+++ b/databases/duckdb/pkg-plist
@@ -10,6 +10,7 @@ include/duckdb/catalog/catalog_entry/copy_function_catalog_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
+include/duckdb/catalog/catalog_entry/function_entry.hpp
 include/duckdb/catalog/catalog_entry/index_catalog_entry.hpp
 include/duckdb/catalog/catalog_entry/list.hpp
 include/duckdb/catalog/catalog_entry/macro_catalog_entry.hpp
@@ -24,6 +25,7 @@ include/duckdb/catalog/catalog_entry/table_function_catalog_entry.hpp
 include/duckdb/catalog/catalog_entry/table_macro_catalog_entry.hpp
 include/duckdb/catalog/catalog_entry/type_catalog_entry.hpp
 include/duckdb/catalog/catalog_entry/view_catalog_entry.hpp
+include/duckdb/catalog/catalog_entry_map.hpp
 include/duckdb/catalog/catalog_search_path.hpp
 include/duckdb/catalog/catalog_set.hpp
 include/duckdb/catalog/catalog_transaction.hpp
@@ -39,6 +41,8 @@ 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
+include/duckdb/common/adbc/adbc.hpp
 include/duckdb/common/algorithm.hpp
 include/duckdb/common/allocator.hpp
 include/duckdb/common/array.hpp
@@ -46,11 +50,13 @@ 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/result_arrow_wrapper.hpp
 include/duckdb/common/assert.hpp
 include/duckdb/common/atomic.hpp
 include/duckdb/common/bind_helpers.hpp
+include/duckdb/common/bit_utils.hpp
 include/duckdb/common/bitpacking.hpp
 include/duckdb/common/bitset.hpp
 include/duckdb/common/box_renderer.hpp
@@ -65,20 +71,25 @@ include/duckdb/common/cycle_counter.hpp
 include/duckdb/common/deque.hpp
 include/duckdb/common/dl.hpp
 include/duckdb/common/enum_class_hash.hpp
+include/duckdb/common/enum_util.hpp
 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/date_part_specifier.hpp
+include/duckdb/common/enums/debug_initialize.hpp
 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/join_type.hpp
 include/duckdb/common/enums/joinref_type.hpp
 include/duckdb/common/enums/logical_operator_type.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
+include/duckdb/common/enums/order_preservation_type.hpp
 include/duckdb/common/enums/order_type.hpp
 include/duckdb/common/enums/output_type.hpp
 include/duckdb/common/enums/pending_execution_result.hpp
@@ -103,12 +114,14 @@ 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/fsst.hpp
 include/duckdb/common/fstream.hpp
 include/duckdb/common/gzip_file_system.hpp
 include/duckdb/common/helper.hpp
 include/duckdb/common/hive_partitioning.hpp
-include/duckdb/common/http_stats.hpp
+include/duckdb/common/http_state.hpp
+include/duckdb/common/hugeint.hpp
 include/duckdb/common/index_map.hpp
 include/duckdb/common/index_vector.hpp
 include/duckdb/common/likely.hpp
@@ -116,8 +129,12 @@ include/duckdb/common/limits.hpp
 include/duckdb/common/list.hpp
 include/duckdb/common/local_file_system.hpp
 include/duckdb/common/map.hpp
+include/duckdb/common/memory_safety.hpp
+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/opener_file_system.hpp
 include/duckdb/common/operator/abs.hpp
 include/duckdb/common/operator/add.hpp
 include/duckdb/common/operator/aggregate_operators.hpp
@@ -131,7 +148,10 @@ include/duckdb/common/operator/numeric_binary_operators.hpp
 include/duckdb/common/operator/numeric_cast.hpp
 include/duckdb/common/operator/string_cast.hpp
 include/duckdb/common/operator/subtract.hpp
+include/duckdb/common/optional_idx.hpp
+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
@@ -144,16 +164,23 @@ include/duckdb/common/radix.hpp
 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_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/serialization_traits.hpp
 include/duckdb/common/set.hpp
-include/duckdb/common/single_thread_ptr.hpp
+include/duckdb/common/shared_ptr.hpp
 include/duckdb/common/sort/comparators.hpp
 include/duckdb/common/sort/duckdb_pdqsort.hpp
+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
@@ -165,6 +192,7 @@ include/duckdb/common/thread.hpp
 include/duckdb/common/to_string.hpp
 include/duckdb/common/tree_renderer.hpp
 include/duckdb/common/type_util.hpp
+include/duckdb/common/typedefs.hpp
 include/duckdb/common/types.hpp
 include/duckdb/common/types/arrow_aux_data.hpp
 include/duckdb/common/types/batched_data_collection.hpp
@@ -172,12 +200,13 @@ 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_data_allocator.hpp
-include/duckdb/common/types/column_data_collection.hpp
-include/duckdb/common/types/column_data_collection_iterators.hpp
-include/duckdb/common/types/column_data_collection_segment.hpp
-include/duckdb/common/types/column_data_consumer.hpp
-include/duckdb/common/types/column_data_scan_states.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
+include/duckdb/common/types/column/column_data_collection_segment.hpp
+include/duckdb/common/types/column/column_data_consumer.hpp
+include/duckdb/common/types/column/column_data_scan_states.hpp
+include/duckdb/common/types/column/partitioned_column_data.hpp
 include/duckdb/common/types/conflict_manager.hpp
 include/duckdb/common/types/constraint_conflict_info.hpp
 include/duckdb/common/types/data_chunk.hpp
@@ -188,11 +217,18 @@ include/duckdb/common/types/hash.hpp
 include/duckdb/common/types/hugeint.hpp
 include/duckdb/common/types/hyperloglog.hpp
 include/duckdb/common/types/interval.hpp
+include/duckdb/common/types/list_segment.hpp
 include/duckdb/common/types/null_value.hpp
-include/duckdb/common/types/partitioned_column_data.hpp
-include/duckdb/common/types/row_data_collection.hpp
-include/duckdb/common/types/row_data_collection_scanner.hpp
-include/duckdb/common/types/row_layout.hpp
+include/duckdb/common/types/row/partitioned_tuple_data.hpp
+include/duckdb/common/types/row/row_data_collection.hpp
+include/duckdb/common/types/row/row_data_collection_scanner.hpp
+include/duckdb/common/types/row/row_layout.hpp
+include/duckdb/common/types/row/tuple_data_allocator.hpp
+include/duckdb/common/types/row/tuple_data_collection.hpp
+include/duckdb/common/types/row/tuple_data_iterator.hpp
+include/duckdb/common/types/row/tuple_data_layout.hpp
+include/duckdb/common/types/row/tuple_data_segment.hpp
+include/duckdb/common/types/row/tuple_data_states.hpp
 include/duckdb/common/types/sel_cache.hpp
 include/duckdb/common/types/selection_vector.hpp
 include/duckdb/common/types/string_heap.hpp
@@ -209,6 +245,7 @@ include/duckdb/common/types/vector_buffer.hpp
 include/duckdb/common/types/vector_cache.hpp
 include/duckdb/common/unicode_bar.hpp
 include/duckdb/common/union_by_name.hpp
+include/duckdb/common/unique_ptr.hpp
 include/duckdb/common/unordered_map.hpp
 include/duckdb/common/unordered_set.hpp
 include/duckdb/common/value_operations/value_operations.hpp
@@ -228,6 +265,32 @@ include/duckdb/common/winapi.hpp
 include/duckdb/common/windows.hpp
 include/duckdb/common/windows_undefs.hpp
 include/duckdb/common/windows_util.hpp
+include/duckdb/core_functions/aggregate/algebraic/corr.hpp
+include/duckdb/core_functions/aggregate/algebraic/covar.hpp
+include/duckdb/core_functions/aggregate/algebraic/stddev.hpp
+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/regression/regr_count.hpp
+include/duckdb/core_functions/aggregate/regression/regr_slope.hpp
+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/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/enum_functions.hpp
+include/duckdb/core_functions/scalar/generic_functions.hpp
+include/duckdb/core_functions/scalar/list_functions.hpp
+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/string_functions.hpp
+include/duckdb/core_functions/scalar/struct_functions.hpp
+include/duckdb/core_functions/scalar/union_functions.hpp
 include/duckdb/execution/adaptive_filter.hpp
 include/duckdb/execution/aggregate_hashtable.hpp
 include/duckdb/execution/base_aggregate_hashtable.hpp
@@ -238,14 +301,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/join_hashtable.hpp
 include/duckdb/execution/nested_loop_join.hpp
@@ -277,6 +343,7 @@ include/duckdb/execution/operator/helper/physical_transaction.hpp
 include/duckdb/execution/operator/helper/physical_vacuum.hpp
 include/duckdb/execution/operator/join/outer_join_marker.hpp
 include/duckdb/execution/operator/join/perfect_hash_join_executor.hpp
+include/duckdb/execution/operator/join/physical_asof_join.hpp
 include/duckdb/execution/operator/join/physical_blockwise_nl_join.hpp
 include/duckdb/execution/operator/join/physical_comparison_join.hpp
 include/duckdb/execution/operator/join/physical_cross_product.hpp
@@ -295,14 +362,18 @@ 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/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
 include/duckdb/execution/operator/persistent/physical_delete.hpp
 include/duckdb/execution/operator/persistent/physical_export.hpp
+include/duckdb/execution/operator/persistent/physical_fixed_batch_copy.hpp
 include/duckdb/execution/operator/persistent/physical_insert.hpp
 include/duckdb/execution/operator/persistent/physical_update.hpp
+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
@@ -328,23 +399,15 @@ 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_segment_tree.hpp
-include/duckdb/function/aggregate/algebraic/corr.hpp
-include/duckdb/function/aggregate/algebraic/covar.hpp
-include/duckdb/function/aggregate/algebraic/stddev.hpp
-include/duckdb/function/aggregate/algebraic_functions.hpp
 include/duckdb/function/aggregate/distributive_functions.hpp
-include/duckdb/function/aggregate/holistic_functions.hpp
-include/duckdb/function/aggregate/nested_functions.hpp
-include/duckdb/function/aggregate/regression/regr_count.hpp
-include/duckdb/function/aggregate/regression/regr_slope.hpp
-include/duckdb/function/aggregate/regression_functions.hpp
-include/duckdb/function/aggregate/sum_helpers.hpp
 include/duckdb/function/aggregate_function.hpp
 include/duckdb/function/built_in_functions.hpp
+include/duckdb/function/cast/bound_cast_data.hpp
 include/duckdb/function/cast/cast_function_set.hpp
 include/duckdb/function/cast/default_casts.hpp
 include/duckdb/function/cast/vector_cast_helpers.hpp
@@ -360,20 +423,14 @@ 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/bit_functions.hpp
-include/duckdb/function/scalar/blob_functions.hpp
-include/duckdb/function/scalar/date_functions.hpp
-include/duckdb/function/scalar/enum_functions.hpp
 include/duckdb/function/scalar/generic_functions.hpp
-include/duckdb/function/scalar/math_functions.hpp
+include/duckdb/function/scalar/list/contains_or_position.hpp
 include/duckdb/function/scalar/nested_functions.hpp
 include/duckdb/function/scalar/operators.hpp
 include/duckdb/function/scalar/regexp.hpp
 include/duckdb/function/scalar/sequence_functions.hpp
-include/duckdb/function/scalar/strftime.hpp
+include/duckdb/function/scalar/strftime_format.hpp
 include/duckdb/function/scalar/string_functions.hpp
-include/duckdb/function/scalar/trigonometric_functions.hpp
-include/duckdb/function/scalar/uuid_functions.hpp
 include/duckdb/function/scalar_function.hpp
 include/duckdb/function/scalar_macro_function.hpp
 include/duckdb/function/table/arrow.hpp
@@ -402,13 +459,14 @@ include/duckdb/main/connection.hpp
 include/duckdb/main/connection_manager.hpp
 include/duckdb/main/database.hpp
 include/duckdb/main/database_manager.hpp
+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_entries.hpp
 include/duckdb/main/extension_helper.hpp
+include/duckdb/main/extension_util.hpp
 include/duckdb/main/external_dependencies.hpp
-include/duckdb/main/loadable_extension.hpp
 include/duckdb/main/materialized_query_result.hpp
 include/duckdb/main/pending_query_result.hpp
 include/duckdb/main/prepared_statement.hpp
@@ -487,6 +545,7 @@ include/duckdb/optimizer/rule/in_clause_simplification.hpp
 include/duckdb/optimizer/rule/like_optimizations.hpp
 include/duckdb/optimizer/rule/list.hpp
 include/duckdb/optimizer/rule/move_constants.hpp
+include/duckdb/optimizer/rule/ordered_aggregate_optimizer.hpp
 include/duckdb/optimizer/rule/regex_optimizations.hpp
 include/duckdb/optimizer/statistics_propagator.hpp
 include/duckdb/optimizer/topn_optimizer.hpp
@@ -494,6 +553,7 @@ include/duckdb/optimizer/unnest_rewriter.hpp
 include/duckdb/parallel/base_pipeline_event.hpp
 include/duckdb/parallel/concurrentqueue.hpp
 include/duckdb/parallel/event.hpp
+include/duckdb/parallel/interrupt.hpp
 include/duckdb/parallel/meta_pipeline.hpp
 include/duckdb/parallel/pipeline.hpp
 include/duckdb/parallel/pipeline_complete_event.hpp
@@ -538,8 +598,9 @@ include/duckdb/parser/expression_map.hpp
 include/duckdb/parser/expression_util.hpp
 include/duckdb/parser/group_by_node.hpp
 include/duckdb/parser/keyword_helper.hpp
-include/duckdb/parser/parsed_data/alter_function_info.hpp
 include/duckdb/parser/parsed_data/alter_info.hpp
+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/copy_info.hpp
@@ -573,10 +634,12 @@ include/duckdb/parser/parsed_expression.hpp
 include/duckdb/parser/parsed_expression_iterator.hpp
 include/duckdb/parser/parser.hpp
 include/duckdb/parser/parser_extension.hpp
+include/duckdb/parser/parser_options.hpp
 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/list.hpp
 include/duckdb/parser/query_node/recursive_cte_node.hpp
 include/duckdb/parser/query_node/select_node.hpp
 include/duckdb/parser/query_node/set_operation_node.hpp
@@ -599,6 +662,7 @@ include/duckdb/parser/statement/insert_statement.hpp
 include/duckdb/parser/statement/list.hpp
 include/duckdb/parser/statement/load_statement.hpp
 include/duckdb/parser/statement/logical_plan_statement.hpp
+include/duckdb/parser/statement/multi_statement.hpp
 include/duckdb/parser/statement/pragma_statement.hpp
 include/duckdb/parser/statement/prepare_statement.hpp
 include/duckdb/parser/statement/relation_statement.hpp
@@ -614,6 +678,7 @@ include/duckdb/parser/tableref/emptytableref.hpp
 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/subqueryref.hpp
 include/duckdb/parser/tableref/table_function_ref.hpp
 include/duckdb/parser/tokens.hpp
@@ -658,6 +723,7 @@ include/duckdb/planner/expression/list.hpp
 include/duckdb/planner/expression_binder.hpp
 include/duckdb/planner/expression_binder/aggregate_binder.hpp
 include/duckdb/planner/expression_binder/alter_binder.hpp
+include/duckdb/planner/expression_binder/base_select_binder.hpp
 include/duckdb/planner/expression_binder/check_binder.hpp
 include/duckdb/planner/expression_binder/column_alias_binder.hpp
 include/duckdb/planner/expression_binder/constant_binder.hpp
@@ -685,6 +751,7 @@ 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
@@ -711,6 +778,7 @@ 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_order.hpp
+include/duckdb/planner/operator/logical_pivot.hpp
 include/duckdb/planner/operator/logical_positional_join.hpp
 include/duckdb/planner/operator/logical_pragma.hpp
 include/duckdb/planner/operator/logical_prepare.hpp
@@ -736,6 +804,7 @@ include/duckdb/planner/pragma_handler.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/rewrite_correlated_expressions.hpp
@@ -746,6 +815,7 @@ include/duckdb/planner/tableref/bound_cteref.hpp
 include/duckdb/planner/tableref/bound_dummytableref.hpp
 include/duckdb/planner/tableref/bound_expressionlistref.hpp
 include/duckdb/planner/tableref/bound_joinref.hpp
+include/duckdb/planner/tableref/bound_pivotref.hpp
 include/duckdb/planner/tableref/bound_pos_join_ref.hpp
 include/duckdb/planner/tableref/bound_subqueryref.hpp
 include/duckdb/planner/tableref/bound_table_function.hpp
@@ -755,6 +825,8 @@ include/duckdb/storage/block.hpp
 include/duckdb/storage/block_manager.hpp
 include/duckdb/storage/buffer/block_handle.hpp
 include/duckdb/storage/buffer/buffer_handle.hpp
+include/duckdb/storage/buffer/buffer_pool.hpp
+include/duckdb/storage/buffer/temporary_file_information.hpp
 include/duckdb/storage/buffer_manager.hpp
 include/duckdb/storage/checkpoint/row_group_writer.hpp
 include/duckdb/storage/checkpoint/string_checkpoint_state.hpp
@@ -795,19 +867,21 @@ include/duckdb/storage/magic_bytes.hpp
 include/duckdb/storage/meta_block_reader.hpp
 include/duckdb/storage/meta_block_writer.hpp
 include/duckdb/storage/object_cache.hpp
+include/duckdb/storage/optimistic_data_writer.hpp
 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/base_statistics.hpp
 include/duckdb/storage/statistics/column_statistics.hpp
 include/duckdb/storage/statistics/distinct_statistics.hpp
-include/duckdb/storage/statistics/list_statistics.hpp
+include/duckdb/storage/statistics/list_stats.hpp
 include/duckdb/storage/statistics/node_statistics.hpp
-include/duckdb/storage/statistics/numeric_statistics.hpp
+include/duckdb/storage/statistics/numeric_stats.hpp
+include/duckdb/storage/statistics/numeric_stats_union.hpp
 include/duckdb/storage/statistics/segment_statistics.hpp
-include/duckdb/storage/statistics/string_statistics.hpp
-include/duckdb/storage/statistics/struct_statistics.hpp
-include/duckdb/storage/statistics/validity_statistics.hpp
+include/duckdb/storage/statistics/string_stats.hpp
+include/duckdb/storage/statistics/struct_stats.hpp
 include/duckdb/storage/storage_extension.hpp
 include/duckdb/storage/storage_info.hpp
 include/duckdb/storage/storage_lock.hpp
@@ -819,11 +893,13 @@ include/duckdb/storage/table/column_checkpoint_state.hpp
 include/duckdb/storage/table/column_data.hpp
 include/duckdb/storage/table/column_data_checkpointer.hpp
 include/duckdb/storage/table/column_segment.hpp
+include/duckdb/storage/table/column_segment_tree.hpp
 include/duckdb/storage/table/data_table_info.hpp
 include/duckdb/storage/table/list_column_data.hpp
 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/scan_state.hpp
 include/duckdb/storage/table/segment_base.hpp
 include/duckdb/storage/table/segment_lock.hpp
@@ -854,7 +930,9 @@ 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
 include/duckdb/verification/prepared_statement_verifier.hpp
 include/duckdb/verification/statement_verifier.hpp
diff --git a/databases/py-duckdb/Makefile b/databases/py-duckdb/Makefile
index a82f9627146f..adadde9151bf 100644
--- a/databases/py-duckdb/Makefile
+++ b/databases/py-duckdb/Makefile
@@ -1,6 +1,5 @@
 PORTNAME=	duckdb
-DISTVERSION=	0.7.1
-PORTREVISION=	1
+DISTVERSION=	0.8.0
 CATEGORIES=	databases python
 MASTER_SITES=	PYPI
 PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
diff --git a/databases/py-duckdb/distinfo b/databases/py-duckdb/distinfo
index 44ad703a590e..da2e9c649418 100644
--- a/databases/py-duckdb/distinfo
+++ b/databases/py-duckdb/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1677520947
-SHA256 (duckdb-0.7.1.tar.gz) = a7db6da0366b239ea1e4541fcc19556b286872f5015c9a54c2e347146e25a2ad
-SIZE (duckdb-0.7.1.tar.gz) = 10536920
+TIMESTAMP = 1684479307
+SHA256 (duckdb-0.8.0.tar.gz) = c68da35bab5072a64ada2646a5b343da620ddc75a7a6e84aa4a1e0628a7ec18f
+SIZE (duckdb-0.8.0.tar.gz) = 10408075