# DuckDB Documentation

> Comprehensive documentation for DuckDB, an in-process analytical database management system.

## Clients

- [ADBC Client](https://duckdb.org/docs/stable/clients/adbc)
- [C++ API](https://duckdb.org/docs/stable/clients/cpp)
- [Client Overview](https://duckdb.org/docs/stable/clients/overview)
- [Dart Client](https://duckdb.org/docs/stable/clients/dart)
- [Go Client](https://duckdb.org/docs/stable/clients/go)
- [Java JDBC Client](https://duckdb.org/docs/stable/clients/java)
- [Julia Client](https://duckdb.org/docs/stable/clients/julia)
- [R Client](https://duckdb.org/docs/stable/clients/r)
- [Rust Client](https://duckdb.org/docs/stable/clients/rust)
- [Swift Client](https://duckdb.org/docs/stable/clients/swift)

## Clients C

- [Appender](https://duckdb.org/docs/stable/clients/c/appender)
- [Complete API](https://duckdb.org/docs/stable/clients/c/api)
- [Configuration](https://duckdb.org/docs/stable/clients/c/config)
- [Data Chunks](https://duckdb.org/docs/stable/clients/c/data_chunk)
- [Overview](https://duckdb.org/docs/stable/clients/c/overview)
- [Prepared Statements](https://duckdb.org/docs/stable/clients/c/prepared)
- [Query](https://duckdb.org/docs/stable/clients/c/query)
- [Replacement Scans](https://duckdb.org/docs/stable/clients/c/replacement_scans)
- [Startup & Shutdown](https://duckdb.org/docs/stable/clients/c/connect)
- [Table Functions](https://duckdb.org/docs/stable/clients/c/table_functions)
- [Types](https://duckdb.org/docs/stable/clients/c/types)
- [Values](https://duckdb.org/docs/stable/clients/c/value)
- [Vectors](https://duckdb.org/docs/stable/clients/c/vector)

## Clients Cli

- [Autocomplete](https://duckdb.org/docs/stable/clients/cli/autocomplete)
- [CLI API](https://duckdb.org/docs/stable/clients/cli/overview)
- [Command Line Arguments](https://duckdb.org/docs/stable/clients/cli/arguments)
- [Dot Commands](https://duckdb.org/docs/stable/clients/cli/dot_commands)
- [Editing](https://duckdb.org/docs/stable/clients/cli/editing)
- [Output Formats](https://duckdb.org/docs/stable/clients/cli/output_formats)
- [Safe Mode](https://duckdb.org/docs/stable/clients/cli/safe_mode)
- [Syntax Highlighting](https://duckdb.org/docs/stable/clients/cli/syntax_highlighting)

## Clients Node_Neo

- [Node.js Client (Neo)](https://duckdb.org/docs/stable/clients/node_neo/overview)

## Clients Nodejs

- [Node.js API](https://duckdb.org/docs/stable/clients/nodejs/reference)
- [Node.js API](https://duckdb.org/docs/stable/clients/nodejs/overview)

## Clients Odbc

- [ODBC API Overview](https://duckdb.org/docs/stable/clients/odbc/overview)
- [ODBC API on Linux](https://duckdb.org/docs/stable/clients/odbc/linux)
- [ODBC API on Windows](https://duckdb.org/docs/stable/clients/odbc/windows)
- [ODBC API on macOS](https://duckdb.org/docs/stable/clients/odbc/macos)
- [ODBC Configuration](https://duckdb.org/docs/stable/clients/odbc/configuration)

## Clients Python

- [Conversion between DuckDB and Python](https://duckdb.org/docs/stable/clients/python/conversion)
- [Data Ingestion](https://duckdb.org/docs/stable/clients/python/data_ingestion)
- [Expression API](https://duckdb.org/docs/stable/clients/python/expression)
- [Known Python Issues](https://duckdb.org/docs/stable/clients/python/known_issues)
- [Python API](https://duckdb.org/docs/stable/clients/python/overview)
- [Python DB API](https://duckdb.org/docs/stable/clients/python/dbapi)
- [Python Function API](https://duckdb.org/docs/stable/clients/python/function)
- [Relational API](https://duckdb.org/docs/stable/clients/python/relational_api)
- [Spark API](https://duckdb.org/docs/stable/clients/python/spark_api)
- [Types API](https://duckdb.org/docs/stable/clients/python/types)

## Clients Python Reference

- [Python Client API](https://duckdb.org/docs/stable/clients/python/reference/index)

## Clients Wasm

- [Data Ingestion](https://duckdb.org/docs/stable/clients/wasm/data_ingestion)
- [DuckDB Wasm](https://duckdb.org/docs/stable/clients/wasm/overview)
- [Extensions](https://duckdb.org/docs/stable/clients/wasm/extensions)
- [Instantiation](https://duckdb.org/docs/stable/clients/wasm/instantiation)
- [Query](https://duckdb.org/docs/stable/clients/wasm/query)

## Configuration

- [Configuration](https://duckdb.org/docs/stable/configuration/overview)
- [Pragmas](https://duckdb.org/docs/stable/configuration/pragmas)
- [Secrets Manager](https://duckdb.org/docs/stable/configuration/secrets_manager)

## Connect

- [Concurrency](https://duckdb.org/docs/stable/connect/concurrency)
- [Connect](https://duckdb.org/docs/stable/connect/overview)

## Data

- [Appender](https://duckdb.org/docs/stable/data/appender)
- [Data Sources](https://duckdb.org/docs/stable/data/data_sources)
- [INSERT Statements](https://duckdb.org/docs/stable/data/insert)
- [Importing Data](https://duckdb.org/docs/stable/data/overview)

## Data Csv

- [CSV Auto Detection](https://duckdb.org/docs/stable/data/csv/auto_detection)
- [CSV Import](https://duckdb.org/docs/stable/data/csv/overview)
- [CSV Import Tips](https://duckdb.org/docs/stable/data/csv/tips)
- [Reading Faulty CSV Files](https://duckdb.org/docs/stable/data/csv/reading_faulty_csv_files)

## Data Json

- [Caveats](https://duckdb.org/docs/stable/data/json/caveats)
- [Creating JSON](https://duckdb.org/docs/stable/data/json/creating_json)
- [Installing and Loading the JSON extension](https://duckdb.org/docs/stable/data/json/installing_and_loading)
- [JSON Format Settings](https://duckdb.org/docs/stable/data/json/format_settings)
- [JSON Overview](https://duckdb.org/docs/stable/data/json/overview)
- [JSON Processing Functions](https://duckdb.org/docs/stable/data/json/json_functions)
- [JSON Type](https://duckdb.org/docs/stable/data/json/json_type)
- [Loading JSON](https://duckdb.org/docs/stable/data/json/loading_json)
- [SQL to/from JSON](https://duckdb.org/docs/stable/data/json/sql_to_and_from_json)
- [Writing JSON](https://duckdb.org/docs/stable/data/json/writing_json)

## Data Multiple_Files

- [Combining Schemas](https://duckdb.org/docs/stable/data/multiple_files/combining_schemas)
- [Reading Multiple Files](https://duckdb.org/docs/stable/data/multiple_files/overview)

## Data Parquet

- [Parquet Encryption](https://duckdb.org/docs/stable/data/parquet/encryption)
- [Parquet Tips](https://duckdb.org/docs/stable/data/parquet/tips)
- [Querying Parquet Metadata](https://duckdb.org/docs/stable/data/parquet/metadata)
- [Reading and Writing Parquet Files](https://duckdb.org/docs/stable/data/parquet/overview)

## Data Partitioning

- [Hive Partitioning](https://duckdb.org/docs/stable/data/partitioning/hive_partitioning)
- [Partitioned Writes](https://duckdb.org/docs/stable/data/partitioning/partitioned_writes)

## Dev

- [Benchmark Suite](https://duckdb.org/docs/stable/dev/benchmark)
- [DuckDB Repositories](https://duckdb.org/docs/stable/dev/repositories)
- [Internal Errors](https://duckdb.org/docs/stable/dev/internal_errors)
- [Profiling](https://duckdb.org/docs/stable/dev/profiling)

## Dev Building

- [Android](https://duckdb.org/docs/stable/dev/building/android)
- [Building Configuration](https://duckdb.org/docs/stable/dev/building/build_configuration)
- [Building DuckDB from Source](https://duckdb.org/docs/stable/dev/building/overview)
- [Building Extensions](https://duckdb.org/docs/stable/dev/building/building_extensions)
- [Linux](https://duckdb.org/docs/stable/dev/building/linux)
- [Python](https://duckdb.org/docs/stable/dev/building/python)
- [R](https://duckdb.org/docs/stable/dev/building/r)
- [Raspberry Pi](https://duckdb.org/docs/stable/dev/building/raspberry_pi)
- [Troubleshooting](https://duckdb.org/docs/stable/dev/building/troubleshooting)
- [Unofficial and Unsupported Platforms](https://duckdb.org/docs/stable/dev/building/unofficial_and_unsupported_platforms)
- [Windows](https://duckdb.org/docs/stable/dev/building/windows)
- [macOS](https://duckdb.org/docs/stable/dev/building/macos)

## Dev Sqllogictest

- [Catch C/C++ Tests](https://duckdb.org/docs/stable/dev/sqllogictest/catch)
- [Debugging](https://duckdb.org/docs/stable/dev/sqllogictest/debugging)
- [Loops](https://duckdb.org/docs/stable/dev/sqllogictest/loops)
- [Multiple Connections](https://duckdb.org/docs/stable/dev/sqllogictest/multiple_connections)
- [Overview](https://duckdb.org/docs/stable/dev/sqllogictest/overview)
- [Persistent Testing](https://duckdb.org/docs/stable/dev/sqllogictest/persistent_testing)
- [Result Verification](https://duckdb.org/docs/stable/dev/sqllogictest/result_verification)
- [Writing Tests](https://duckdb.org/docs/stable/dev/sqllogictest/writing_tests)
- [sqllogictest Introduction](https://duckdb.org/docs/stable/dev/sqllogictest/intro)

## Extensions

- [AWS Extension](https://duckdb.org/docs/stable/extensions/aws)
- [Advanced Installation Methods](https://duckdb.org/docs/stable/extensions/advanced_installation_methods)
- [Arrow Extension](https://duckdb.org/docs/stable/extensions/arrow)
- [AutoComplete Extension](https://duckdb.org/docs/stable/extensions/autocomplete)
- [Avro Extension](https://duckdb.org/docs/stable/extensions/avro)
- [Azure Extension](https://duckdb.org/docs/stable/extensions/azure)
- [Community Extensions](https://duckdb.org/docs/stable/extensions/community_extensions)
- [Core Extensions](https://duckdb.org/docs/stable/extensions/core_extensions)
- [Delta Extension](https://duckdb.org/docs/stable/extensions/delta)
- [Excel Extension](https://duckdb.org/docs/stable/extensions/excel)
- [Extension Distribution](https://duckdb.org/docs/stable/extensions/extension_distribution)
- [Extensions](https://duckdb.org/docs/stable/extensions/overview)
- [Full-Text Search Extension](https://duckdb.org/docs/stable/extensions/full_text_search)
- [ICU Extension](https://duckdb.org/docs/stable/extensions/icu)
- [Installing Extensions](https://duckdb.org/docs/stable/extensions/installing_extensions)
- [MySQL Extension](https://duckdb.org/docs/stable/extensions/mysql)
- [PostgreSQL Extension](https://duckdb.org/docs/stable/extensions/postgres)
- [SQLSmith Extension](https://duckdb.org/docs/stable/extensions/sqlsmith)
- [SQLite Extension](https://duckdb.org/docs/stable/extensions/sqlite)
- [TPC-DS Extension](https://duckdb.org/docs/stable/extensions/tpcds)
- [TPC-H Extension](https://duckdb.org/docs/stable/extensions/tpch)
- [Troubleshooting of Extensions](https://duckdb.org/docs/stable/extensions/troubleshooting)
- [UI Extension](https://duckdb.org/docs/stable/extensions/ui)
- [Vector Similarity Search Extension](https://duckdb.org/docs/stable/extensions/vss)
- [Versioning of Extensions](https://duckdb.org/docs/stable/extensions/versioning_of_extensions)
- [inet Extension](https://duckdb.org/docs/stable/extensions/inet)
- [jemalloc Extension](https://duckdb.org/docs/stable/extensions/jemalloc)

## Extensions Httpfs

- [HTTP(S) Support](https://duckdb.org/docs/stable/extensions/httpfs/https)
- [Hugging Face Support](https://duckdb.org/docs/stable/extensions/httpfs/hugging_face)
- [Legacy Authentication Scheme for S3 API](https://duckdb.org/docs/stable/extensions/httpfs/s3api_legacy_authentication)
- [S3 API Support](https://duckdb.org/docs/stable/extensions/httpfs/s3api)
- [httpfs Extension for HTTP and S3 Support](https://duckdb.org/docs/stable/extensions/httpfs/overview)

## Extensions Iceberg

- [Amazon S3 Tables](https://duckdb.org/docs/stable/extensions/iceberg/amazon_s3_tables)
- [Amazon SageMaker Lakehouse (AWS Glue)](https://duckdb.org/docs/stable/extensions/iceberg/amazon_sagemaker_lakehouse)
- [Iceberg Extension](https://duckdb.org/docs/stable/extensions/iceberg/overview)
- [Troubleshooting](https://duckdb.org/docs/stable/extensions/iceberg/troubleshooting)

## Extensions Spatial

- [GDAL Integration](https://duckdb.org/docs/stable/extensions/spatial/gdal)
- [R-Tree Indexes](https://duckdb.org/docs/stable/extensions/spatial/r-tree_indexes)
- [Spatial Extension](https://duckdb.org/docs/stable/extensions/spatial/overview)
- [Spatial Functions](https://duckdb.org/docs/stable/extensions/spatial/functions)

## Guides

- [Browsing Offline](https://duckdb.org/docs/stable/guides/offline-copy)
- [Glossary of Terms](https://duckdb.org/docs/stable/guides/glossary)
- [Guides](https://duckdb.org/docs/stable/guides/overview)

## Guides Data_Viewers

- [CLI Charting with YouPlot](https://duckdb.org/docs/stable/guides/data_viewers/youplot)
- [Tableau – A Data Visualization Tool](https://duckdb.org/docs/stable/guides/data_viewers/tableau)

## Guides Database_Integration

- [Database Integration](https://duckdb.org/docs/stable/guides/database_integration/overview)
- [MySQL Import](https://duckdb.org/docs/stable/guides/database_integration/mysql)
- [PostgreSQL Import](https://duckdb.org/docs/stable/guides/database_integration/postgres)
- [SQLite Import](https://duckdb.org/docs/stable/guides/database_integration/sqlite)

## Guides File_Formats

- [CSV Export](https://duckdb.org/docs/stable/guides/file_formats/csv_export)
- [CSV Import](https://duckdb.org/docs/stable/guides/file_formats/csv_import)
- [Directly Reading Files](https://duckdb.org/docs/stable/guides/file_formats/read_file)
- [Excel Export](https://duckdb.org/docs/stable/guides/file_formats/excel_export)
- [Excel Import](https://duckdb.org/docs/stable/guides/file_formats/excel_import)
- [File Access with the file: Protocol](https://duckdb.org/docs/stable/guides/file_formats/file_access)
- [File Formats](https://duckdb.org/docs/stable/guides/file_formats/overview)
- [JSON Export](https://duckdb.org/docs/stable/guides/file_formats/json_export)
- [JSON Import](https://duckdb.org/docs/stable/guides/file_formats/json_import)
- [Parquet Export](https://duckdb.org/docs/stable/guides/file_formats/parquet_export)
- [Parquet Import](https://duckdb.org/docs/stable/guides/file_formats/parquet_import)
- [Querying Parquet Files](https://duckdb.org/docs/stable/guides/file_formats/query_parquet)

## Guides Meta

- [Describe](https://duckdb.org/docs/stable/guides/meta/describe)
- [DuckDB Environment](https://duckdb.org/docs/stable/guides/meta/duckdb_environment)
- [EXPLAIN ANALYZE: Profile Queries](https://duckdb.org/docs/stable/guides/meta/explain_analyze)
- [EXPLAIN: Inspect Query Plans](https://duckdb.org/docs/stable/guides/meta/explain)
- [List Tables](https://duckdb.org/docs/stable/guides/meta/list_tables)
- [Summarize](https://duckdb.org/docs/stable/guides/meta/summarize)

## Guides Network_Cloud_Storage

- [Attach to a DuckDB Database over HTTPS or S3](https://duckdb.org/docs/stable/guides/network_cloud_storage/duckdb_over_https_or_s3)
- [Cloudflare R2 Import](https://duckdb.org/docs/stable/guides/network_cloud_storage/cloudflare_r2_import)
- [Fastly Object Storage Import](https://duckdb.org/docs/stable/guides/network_cloud_storage/fastly_object_storage_import)
- [Google Cloud Storage Import](https://duckdb.org/docs/stable/guides/network_cloud_storage/gcs_import)
- [HTTP Parquet Import](https://duckdb.org/docs/stable/guides/network_cloud_storage/http_import)
- [Network and Cloud Storage](https://duckdb.org/docs/stable/guides/network_cloud_storage/overview)
- [S3 Express One](https://duckdb.org/docs/stable/guides/network_cloud_storage/s3_express_one)
- [S3 Iceberg Import](https://duckdb.org/docs/stable/guides/network_cloud_storage/s3_iceberg_import)
- [S3 Parquet Export](https://duckdb.org/docs/stable/guides/network_cloud_storage/s3_export)
- [S3 Parquet Import](https://duckdb.org/docs/stable/guides/network_cloud_storage/s3_import)

## Guides Odbc

- [ODBC 101: A Duck Themed Guide to ODBC](https://duckdb.org/docs/stable/guides/odbc/general)

## Guides Performance

- [Benchmarks](https://duckdb.org/docs/stable/guides/performance/benchmarks)
- [Data Import](https://duckdb.org/docs/stable/guides/performance/import)
- [Environment](https://duckdb.org/docs/stable/guides/performance/environment)
- [File Formats](https://duckdb.org/docs/stable/guides/performance/file_formats)
- [Indexing](https://duckdb.org/docs/stable/guides/performance/indexing)
- [Join Operations](https://duckdb.org/docs/stable/guides/performance/join_operations)
- [My Workload Is Slow](https://duckdb.org/docs/stable/guides/performance/my_workload_is_slow)
- [Performance Guide](https://duckdb.org/docs/stable/guides/performance/overview)
- [Schema](https://duckdb.org/docs/stable/guides/performance/schema)
- [Tuning Workloads](https://duckdb.org/docs/stable/guides/performance/how_to_tune_workloads)

## Guides Python

- [Executing SQL in Python](https://duckdb.org/docs/stable/guides/python/execute_sql)
- [Export to Apache Arrow](https://duckdb.org/docs/stable/guides/python/export_arrow)
- [Export to Numpy](https://duckdb.org/docs/stable/guides/python/export_numpy)
- [Export to Pandas](https://duckdb.org/docs/stable/guides/python/export_pandas)
- [Import from Apache Arrow](https://duckdb.org/docs/stable/guides/python/import_arrow)
- [Import from Numpy](https://duckdb.org/docs/stable/guides/python/import_numpy)
- [Import from Pandas](https://duckdb.org/docs/stable/guides/python/import_pandas)
- [Installing the Python Client](https://duckdb.org/docs/stable/guides/python/install)
- [Integration with Ibis](https://duckdb.org/docs/stable/guides/python/ibis)
- [Integration with Polars](https://duckdb.org/docs/stable/guides/python/polars)
- [Jupyter Notebooks](https://duckdb.org/docs/stable/guides/python/jupyter)
- [Multiple Python Threads](https://duckdb.org/docs/stable/guides/python/multiple_threads)
- [Relational API on Pandas](https://duckdb.org/docs/stable/guides/python/relational_api_pandas)
- [SQL on Apache Arrow](https://duckdb.org/docs/stable/guides/python/sql_on_arrow)
- [SQL on Pandas](https://duckdb.org/docs/stable/guides/python/sql_on_pandas)
- [Using fsspec Filesystems](https://duckdb.org/docs/stable/guides/python/filesystems)

## Guides Snippets

- [Analyzing a Git Repository](https://duckdb.org/docs/stable/guides/snippets/analyze_git_repository)
- [Copying an In-Memory Database to a File](https://duckdb.org/docs/stable/guides/snippets/copy_in-memory_database_to_file)
- [Create Synthetic Data](https://duckdb.org/docs/stable/guides/snippets/create_synthetic_data)
- [Dutch Railway Datasets](https://duckdb.org/docs/stable/guides/snippets/dutch_railway_datasets)
- [Importing Duckbox Tables](https://duckdb.org/docs/stable/guides/snippets/importing_duckbox_tables)
- [Sharing Macros](https://duckdb.org/docs/stable/guides/snippets/sharing_macros)

## Guides Sql_Editors

- [DBeaver SQL IDE](https://duckdb.org/docs/stable/guides/sql_editors/dbeaver)

## Guides Sql_Features

- [AsOf Join](https://duckdb.org/docs/stable/guides/sql_features/asof_join)
- [Full-Text Search](https://duckdb.org/docs/stable/guides/sql_features/full_text_search)
- [query and query_table Functions](https://duckdb.org/docs/stable/guides/sql_features/query_and_query_table_functions)

## Internals

- [Execution Format](https://duckdb.org/docs/stable/internals/vector)
- [Overview of DuckDB Internals](https://duckdb.org/docs/stable/internals/overview)
- [Pivot Internals](https://duckdb.org/docs/stable/internals/pivot)
- [Storage Versions and Format](https://duckdb.org/docs/stable/internals/storage)

## Operations_Manual

- [Limits](https://duckdb.org/docs/stable/operations_manual/limits)
- [Non-Deterministic Behavior](https://duckdb.org/docs/stable/operations_manual/non-deterministic_behavior)
- [Overview](https://duckdb.org/docs/stable/operations_manual/overview)

## Operations_Manual Footprint_Of_Duckdb

- [Files Created by DuckDB](https://duckdb.org/docs/stable/operations_manual/footprint_of_duckdb/files_created_by_duckdb)
- [Gitignore for DuckDB](https://duckdb.org/docs/stable/operations_manual/footprint_of_duckdb/gitignore_for_duckdb)
- [Reclaiming Space](https://duckdb.org/docs/stable/operations_manual/footprint_of_duckdb/reclaiming_space)

## Operations_Manual Logging

- [Logging](https://duckdb.org/docs/stable/operations_manual/logging/overview)

## Operations_Manual Securing_Duckdb

- [Embedding DuckDB](https://duckdb.org/docs/stable/operations_manual/securing_duckdb/embedding_duckdb)
- [Securing DuckDB](https://duckdb.org/docs/stable/operations_manual/securing_duckdb/overview)
- [Securing Extensions](https://duckdb.org/docs/stable/operations_manual/securing_duckdb/securing_extensions)

## Documentation

- [Documentation](https://duckdb.org/docs/stable/index)
- [Search](https://duckdb.org/docs/stable/search)

## Sql

- [Constraints](https://duckdb.org/docs/stable/sql/constraints)
- [Indexes](https://duckdb.org/docs/stable/sql/indexes)
- [SQL Introduction](https://duckdb.org/docs/stable/sql/introduction)
- [Samples](https://duckdb.org/docs/stable/sql/samples)

## Sql Data_Types

- [Array Type](https://duckdb.org/docs/stable/sql/data_types/array)
- [Bitstring Type](https://duckdb.org/docs/stable/sql/data_types/bitstring)
- [Blob Type](https://duckdb.org/docs/stable/sql/data_types/blob)
- [Boolean Type](https://duckdb.org/docs/stable/sql/data_types/boolean)
- [Data Types](https://duckdb.org/docs/stable/sql/data_types/overview)
- [Date Types](https://duckdb.org/docs/stable/sql/data_types/date)
- [Enum Data Type](https://duckdb.org/docs/stable/sql/data_types/enum)
- [Interval Type](https://duckdb.org/docs/stable/sql/data_types/interval)
- [List Type](https://duckdb.org/docs/stable/sql/data_types/list)
- [Literal Types](https://duckdb.org/docs/stable/sql/data_types/literal_types)
- [Map Type](https://duckdb.org/docs/stable/sql/data_types/map)
- [NULL Values](https://duckdb.org/docs/stable/sql/data_types/nulls)
- [Numeric Types](https://duckdb.org/docs/stable/sql/data_types/numeric)
- [Struct Data Type](https://duckdb.org/docs/stable/sql/data_types/struct)
- [Text Types](https://duckdb.org/docs/stable/sql/data_types/text)
- [Time Types](https://duckdb.org/docs/stable/sql/data_types/time)
- [Time Zone Reference List](https://duckdb.org/docs/stable/sql/data_types/timezones)
- [Timestamp Types](https://duckdb.org/docs/stable/sql/data_types/timestamp)
- [Typecasting](https://duckdb.org/docs/stable/sql/data_types/typecasting)
- [Union Type](https://duckdb.org/docs/stable/sql/data_types/union)

## Sql Dialect

- [Friendly SQL](https://duckdb.org/docs/stable/sql/dialect/friendly_sql)
- [Indexing](https://duckdb.org/docs/stable/sql/dialect/indexing)
- [Keywords and Identifiers](https://duckdb.org/docs/stable/sql/dialect/keywords_and_identifiers)
- [Order Preservation](https://duckdb.org/docs/stable/sql/dialect/order_preservation)
- [Overview](https://duckdb.org/docs/stable/sql/dialect/overview)
- [PostgreSQL Compatibility](https://duckdb.org/docs/stable/sql/dialect/postgresql_compatibility)
- [SQL Quirks](https://duckdb.org/docs/stable/sql/dialect/sql_quirks)

## Sql Expressions

- [CASE Expression](https://duckdb.org/docs/stable/sql/expressions/case)
- [Casting](https://duckdb.org/docs/stable/sql/expressions/cast)
- [Collations](https://duckdb.org/docs/stable/sql/expressions/collations)
- [Comparisons](https://duckdb.org/docs/stable/sql/expressions/comparison_operators)
- [Expressions](https://duckdb.org/docs/stable/sql/expressions/overview)
- [IN Operator](https://duckdb.org/docs/stable/sql/expressions/in)
- [Logical Operators](https://duckdb.org/docs/stable/sql/expressions/logical_operators)
- [Star Expression](https://duckdb.org/docs/stable/sql/expressions/star)
- [Subqueries](https://duckdb.org/docs/stable/sql/expressions/subqueries)

## Sql Functions

- [Aggregate Functions](https://duckdb.org/docs/stable/sql/functions/aggregates)
- [Array Functions](https://duckdb.org/docs/stable/sql/functions/array)
- [Bitstring Functions](https://duckdb.org/docs/stable/sql/functions/bitstring)
- [Blob Functions](https://duckdb.org/docs/stable/sql/functions/blob)
- [Date Format Functions](https://duckdb.org/docs/stable/sql/functions/dateformat)
- [Date Functions](https://duckdb.org/docs/stable/sql/functions/date)
- [Date Part Functions](https://duckdb.org/docs/stable/sql/functions/datepart)
- [Enum Functions](https://duckdb.org/docs/stable/sql/functions/enum)
- [Functions](https://duckdb.org/docs/stable/sql/functions/overview)
- [Interval Functions](https://duckdb.org/docs/stable/sql/functions/interval)
- [Lambda Functions](https://duckdb.org/docs/stable/sql/functions/lambda)
- [List Functions](https://duckdb.org/docs/stable/sql/functions/list)
- [Map Functions](https://duckdb.org/docs/stable/sql/functions/map)
- [Nested Functions](https://duckdb.org/docs/stable/sql/functions/nested)
- [Numeric Functions](https://duckdb.org/docs/stable/sql/functions/numeric)
- [Pattern Matching](https://duckdb.org/docs/stable/sql/functions/pattern_matching)
- [Regular Expressions](https://duckdb.org/docs/stable/sql/functions/regular_expressions)
- [Struct Functions](https://duckdb.org/docs/stable/sql/functions/struct)
- [Text Functions](https://duckdb.org/docs/stable/sql/functions/char)
- [Time Functions](https://duckdb.org/docs/stable/sql/functions/time)
- [Timestamp Functions](https://duckdb.org/docs/stable/sql/functions/timestamp)
- [Timestamp with Time Zone Functions](https://duckdb.org/docs/stable/sql/functions/timestamptz)
- [Union Functions](https://duckdb.org/docs/stable/sql/functions/union)
- [Utility Functions](https://duckdb.org/docs/stable/sql/functions/utility)
- [Window Functions](https://duckdb.org/docs/stable/sql/functions/window_functions)

## Sql Meta

- [DuckDB_% Metadata Functions](https://duckdb.org/docs/stable/sql/meta/duckdb_table_functions)
- [Information Schema](https://duckdb.org/docs/stable/sql/meta/information_schema)

## Sql Query_Syntax

- [FILTER Clause](https://duckdb.org/docs/stable/sql/query_syntax/filter)
- [FROM and JOIN Clauses](https://duckdb.org/docs/stable/sql/query_syntax/from)
- [GROUP BY Clause](https://duckdb.org/docs/stable/sql/query_syntax/groupby)
- [GROUPING SETS](https://duckdb.org/docs/stable/sql/query_syntax/grouping_sets)
- [HAVING Clause](https://duckdb.org/docs/stable/sql/query_syntax/having)
- [LIMIT and OFFSET Clauses](https://duckdb.org/docs/stable/sql/query_syntax/limit)
- [ORDER BY Clause](https://duckdb.org/docs/stable/sql/query_syntax/orderby)
- [Prepared Statements](https://duckdb.org/docs/stable/sql/query_syntax/prepared_statements)
- [QUALIFY Clause](https://duckdb.org/docs/stable/sql/query_syntax/qualify)
- [SAMPLE Clause](https://duckdb.org/docs/stable/sql/query_syntax/sample)
- [SELECT Clause](https://duckdb.org/docs/stable/sql/query_syntax/select)
- [Set Operations](https://duckdb.org/docs/stable/sql/query_syntax/setops)
- [Unnesting](https://duckdb.org/docs/stable/sql/query_syntax/unnest)
- [VALUES Clause](https://duckdb.org/docs/stable/sql/query_syntax/values)
- [WHERE Clause](https://duckdb.org/docs/stable/sql/query_syntax/where)
- [WINDOW Clause](https://duckdb.org/docs/stable/sql/query_syntax/window)
- [WITH Clause](https://duckdb.org/docs/stable/sql/query_syntax/with)

## Sql Statements

- [ALTER TABLE Statement](https://duckdb.org/docs/stable/sql/statements/alter_table)
- [ALTER VIEW Statement](https://duckdb.org/docs/stable/sql/statements/alter_view)
- [ANALYZE Statement](https://duckdb.org/docs/stable/sql/statements/analyze)
- [ATTACH and DETACH Statements](https://duckdb.org/docs/stable/sql/statements/attach)
- [CALL Statement](https://duckdb.org/docs/stable/sql/statements/call)
- [CHECKPOINT Statement](https://duckdb.org/docs/stable/sql/statements/checkpoint)
- [COMMENT ON Statement](https://duckdb.org/docs/stable/sql/statements/comment_on)
- [COPY Statement](https://duckdb.org/docs/stable/sql/statements/copy)
- [CREATE INDEX Statement](https://duckdb.org/docs/stable/sql/statements/create_index)
- [CREATE MACRO Statement](https://duckdb.org/docs/stable/sql/statements/create_macro)
- [CREATE SCHEMA Statement](https://duckdb.org/docs/stable/sql/statements/create_schema)
- [CREATE SECRET Statement](https://duckdb.org/docs/stable/sql/statements/create_secret)
- [CREATE SEQUENCE Statement](https://duckdb.org/docs/stable/sql/statements/create_sequence)
- [CREATE TABLE Statement](https://duckdb.org/docs/stable/sql/statements/create_table)
- [CREATE TYPE Statement](https://duckdb.org/docs/stable/sql/statements/create_type)
- [CREATE VIEW Statement](https://duckdb.org/docs/stable/sql/statements/create_view)
- [DELETE Statement](https://duckdb.org/docs/stable/sql/statements/delete)
- [DESCRIBE Statement](https://duckdb.org/docs/stable/sql/statements/describe)
- [DROP Statement](https://duckdb.org/docs/stable/sql/statements/drop)
- [EXPORT and IMPORT DATABASE Statements](https://duckdb.org/docs/stable/sql/statements/export)
- [INSERT Statement](https://duckdb.org/docs/stable/sql/statements/insert)
- [LOAD / INSTALL Statements](https://duckdb.org/docs/stable/sql/statements/load_and_install)
- [PIVOT Statement](https://duckdb.org/docs/stable/sql/statements/pivot)
- [Profiling Queries](https://duckdb.org/docs/stable/sql/statements/profiling)
- [SELECT Statement](https://duckdb.org/docs/stable/sql/statements/select)
- [SET VARIABLE and RESET VARIABLE Statements](https://duckdb.org/docs/stable/sql/statements/set_variable)
- [SET and RESET Statements](https://duckdb.org/docs/stable/sql/statements/set)
- [SUMMARIZE Statement](https://duckdb.org/docs/stable/sql/statements/summarize)
- [Statements Overview](https://duckdb.org/docs/stable/sql/statements/overview)
- [Transaction Management](https://duckdb.org/docs/stable/sql/statements/transactions)
- [UNPIVOT Statement](https://duckdb.org/docs/stable/sql/statements/unpivot)
- [UPDATE EXTENSIONS](https://duckdb.org/docs/stable/sql/statements/update_extensions)
- [UPDATE Statement](https://duckdb.org/docs/stable/sql/statements/update)
- [USE Statement](https://duckdb.org/docs/stable/sql/statements/use)
- [VACUUM Statement](https://duckdb.org/docs/stable/sql/statements/vacuum)