Skip to contents

String

Operate on text (VARCHAR) values.

array_extract()
DuckDB function array_extract
ascii()
DuckDB function ascii
bar()
DuckDB function bar
bin()
DuckDB function bin
bit_length()
DuckDB function bit_length
chr()
DuckDB function chr
concat()
DuckDB function concat
concat_ws()
DuckDB function concat_ws
contains()
DuckDB function contains
format()
DuckDB function format
formatReadableDecimalSize()
DuckDB function formatReadableDecimalSize
format_bytes()
DuckDB function format_bytes
from_base64()
DuckDB function from_base64
greatest()
DuckDB function greatest
hash()
DuckDB function hash
hex()
DuckDB function hex
ilike_escape()
DuckDB function ilike_escape
instr()
DuckDB function instr
least()
DuckDB function least
left()
DuckDB function left
left_grapheme()
DuckDB function left_grapheme
len()
DuckDB function len
length_grapheme()
DuckDB function length_grapheme
like_escape()
DuckDB function like_escape
list_slice()
DuckDB function list_slice
lower()
DuckDB function lower
lpad()
DuckDB function lpad
ltrim()
DuckDB function ltrim
md5()
DuckDB function md5
md5_number()
DuckDB function md5_number
nfc_normalize()
DuckDB function nfc_normalize
not_ilike_escape()
DuckDB function not_ilike_escape
not_like_escape()
DuckDB function not_like_escape
`||`()
DuckDB function ||
parse_dirname()
DuckDB function parse_dirname
parse_dirpath()
DuckDB function parse_dirpath
parse_filename()
DuckDB function parse_filename
parse_formatted_bytes()
DuckDB function parse_formatted_bytes
parse_path()
DuckDB function parse_path
prefix()
DuckDB function prefix
printf()
DuckDB function printf
`repeat`()
DuckDB function repeat
replace()
DuckDB function replace
reverse()
DuckDB function reverse
right()
DuckDB function right
right_grapheme()
DuckDB function right_grapheme
rpad()
DuckDB function rpad
rtrim()
DuckDB function rtrim
sha1()
DuckDB function sha1
sha256()
DuckDB function sha256
starts_with()
DuckDB function starts_with
string_split()
DuckDB function string_split
strip_accents()
DuckDB function strip_accents
strlen()
DuckDB function strlen
substring()
DuckDB function substring
substring_grapheme()
DuckDB function substring_grapheme
suffix()
DuckDB function suffix
to_base()
DuckDB function to_base
to_base64()
DuckDB function to_base64
translate()
DuckDB function translate
trim()
DuckDB function trim
unbin()
DuckDB function unbin
unhex()
DuckDB function unhex
unicode()
DuckDB function unicode
upper()
DuckDB function upper
url_decode()
DuckDB function url_decode
url_encode()
DuckDB function url_encode

List

Operate on LIST values.

array_extract()
DuckDB function array_extract
array_length()
DuckDB function array_length
concat()
DuckDB function concat
contains()
DuckDB function contains
flatten()
DuckDB function flatten
generate_series()
DuckDB function generate_series
len()
DuckDB function len
list_aggregate()
DuckDB function list_aggregate
list_concat()
DuckDB function list_concat
list_contains()
DuckDB function list_contains
list_cosine_distance()
DuckDB function list_cosine_distance
list_cosine_similarity()
DuckDB function list_cosine_similarity
list_distance()
DuckDB function list_distance
list_distinct()
DuckDB function list_distinct
list_extract()
DuckDB function list_extract
list_filter()
DuckDB function list_filter
list_grade_up()
DuckDB function list_grade_up
list_has_all()
DuckDB function list_has_all
list_has_any()
DuckDB function list_has_any
list_inner_product()
DuckDB function list_inner_product
list_intersect()
DuckDB function list_intersect
list_negative_inner_product()
DuckDB function list_negative_inner_product
list_position()
DuckDB function list_position
list_reduce()
DuckDB function list_reduce
list_resize()
DuckDB function list_resize
list_reverse_sort()
DuckDB function list_reverse_sort
list_select()
DuckDB function list_select
list_slice()
DuckDB function list_slice
list_sort()
DuckDB function list_sort
list_transform()
DuckDB function list_transform
list_unique()
DuckDB function list_unique
list_value()
DuckDB function list_value
list_where()
DuckDB function list_where
list_zip()
DuckDB function list_zip
`||`()
DuckDB function ||
range()
DuckDB function range
`repeat`()
DuckDB function repeat
unpivot_list()
DuckDB function unpivot_list

Array

Operate on fixed-size ARRAY values.

array_cosine_distance()
DuckDB function array_cosine_distance
array_cosine_similarity()
DuckDB function array_cosine_similarity
array_cross_product()
DuckDB function array_cross_product
array_distance()
DuckDB function array_distance
array_inner_product()
DuckDB function array_inner_product
array_negative_inner_product()
DuckDB function array_negative_inner_product
array_value()
DuckDB function array_value

Struct

Operate on STRUCT values.

array_extract()
DuckDB function array_extract

Map

Operate on MAP values.

contains()
DuckDB function contains

Variant

Operate on VARIANT values.

variant_extract()
DuckDB function variant_extract
variant_normalize()
DuckDB function variant_normalize
variant_typeof()
DuckDB function variant_typeof

Numeric

Numeric and mathematical functions.

bin()
DuckDB function bin
bit_length()
DuckDB function bit_length
formatReadableDecimalSize()
DuckDB function formatReadableDecimalSize
format_bytes()
DuckDB function format_bytes
greatest()
DuckDB function greatest
hex()
DuckDB function hex
least()
DuckDB function least
len()
DuckDB function len
parse_formatted_bytes()
DuckDB function parse_formatted_bytes
to_base()
DuckDB function to_base

Bitstring

Operate on BIT (bitstring) values.

octet_length()
DuckDB function octet_length

Blob

Operate on binary large objects (BLOB).

decode()
DuckDB function decode
encode()
DuckDB function encode
from_base64()
DuckDB function from_base64
hex()
DuckDB function hex
md5()
DuckDB function md5
md5_number()
DuckDB function md5_number
octet_length()
DuckDB function octet_length
`||`()
DuckDB function ||
`repeat`()
DuckDB function repeat
sha1()
DuckDB function sha1
sha256()
DuckDB function sha256
to_base64()
DuckDB function to_base64
unbin()
DuckDB function unbin
unhex()
DuckDB function unhex

Date

Operate on DATE values.

greatest()
DuckDB function greatest
least()
DuckDB function least

Timestamp

Operate on TIMESTAMP values.

greatest()
DuckDB function greatest
least()
DuckDB function least

Regular expressions

Match and extract with regular expressions.

regexp_escape()
DuckDB function regexp_escape
regexp_extract()
DuckDB function regexp_extract
regexp_extract_all()
DuckDB function regexp_extract_all
regexp_full_match()
DuckDB function regexp_full_match
regexp_matches()
DuckDB function regexp_matches
regexp_replace()
DuckDB function regexp_replace
string_split_regex()
DuckDB function string_split_regex

Text similarity

Measure similarity or distance between strings.

damerau_levenshtein()
DuckDB function damerau_levenshtein
hamming()
DuckDB function hamming
jaccard()
DuckDB function jaccard
jaro_similarity()
DuckDB function jaro_similarity
jaro_winkler_similarity()
DuckDB function jaro_winkler_similarity
levenshtein()
DuckDB function levenshtein

Lambda

Higher-order functions taking lambda expressions.

list_filter()
DuckDB function list_filter
list_reduce()
DuckDB function list_reduce
list_transform()
DuckDB function list_transform

Geometry

Spatial and geometry functions.

st_astext()
DuckDB function st_astext
st_aswkb()
DuckDB function st_aswkb
st_crs()
DuckDB function st_crs
st_geomfromwkb()
DuckDB function st_geomfromwkb

Aggregate

Aggregate functions.

greatest()
DuckDB function greatest
least()
DuckDB function least

Other functions

Functions that DuckDB does not assign to a category.

DuckDB_PROJ_Compiled_Version()
DuckDB function DuckDB_PROJ_Compiled_Version
DuckDB_Proj_Version()
DuckDB function DuckDB_Proj_Version
ST_Affine()
DuckDB function ST_Affine
ST_Area()
DuckDB function ST_Area
ST_Area_Spheroid()
DuckDB function ST_Area_Spheroid
ST_AsGeoJSON()
DuckDB function ST_AsGeoJSON
ST_AsHEXWKB()
DuckDB function ST_AsHEXWKB
ST_AsMVT()
DuckDB function ST_AsMVT
ST_AsMVTGeom()
DuckDB function ST_AsMVTGeom
ST_AsSVG()
DuckDB function ST_AsSVG
ST_Azimuth()
DuckDB function ST_Azimuth
ST_Boundary()
DuckDB function ST_Boundary
ST_Buffer()
DuckDB function ST_Buffer
ST_BuildArea()
DuckDB function ST_BuildArea
ST_Centroid()
DuckDB function ST_Centroid
ST_ClosestPoint()
DuckDB function ST_ClosestPoint
ST_Collect()
DuckDB function ST_Collect
ST_CollectionExtract()
DuckDB function ST_CollectionExtract
ST_ConcaveHull()
DuckDB function ST_ConcaveHull
ST_Contains()
DuckDB function ST_Contains
ST_ContainsProperly()
DuckDB function ST_ContainsProperly
ST_ConvexHull()
DuckDB function ST_ConvexHull
ST_CoverageClean()
DuckDB function ST_CoverageClean
ST_CoverageInvalidEdges()
DuckDB function ST_CoverageInvalidEdges
ST_CoverageInvalidEdges_Agg()
DuckDB function ST_CoverageInvalidEdges_Agg
ST_CoverageSimplify()
DuckDB function ST_CoverageSimplify
ST_CoverageSimplify_Agg()
DuckDB function ST_CoverageSimplify_Agg
ST_CoverageUnion()
DuckDB function ST_CoverageUnion
ST_CoverageUnion_Agg()
DuckDB function ST_CoverageUnion_Agg
ST_CoveredBy()
DuckDB function ST_CoveredBy
ST_Covers()
DuckDB function ST_Covers
ST_Crosses()
DuckDB function ST_Crosses
ST_DWithin()
DuckDB function ST_DWithin
ST_DWithin_GEOS()
DuckDB function ST_DWithin_GEOS
ST_DWithin_Spheroid()
DuckDB function ST_DWithin_Spheroid
ST_Difference()
DuckDB function ST_Difference
ST_Dimension()
DuckDB function ST_Dimension
ST_Disjoint()
DuckDB function ST_Disjoint
ST_Distance()
DuckDB function ST_Distance
ST_Distance_GEOS()
DuckDB function ST_Distance_GEOS
ST_Distance_Sphere()
DuckDB function ST_Distance_Sphere
ST_Distance_Spheroid()
DuckDB function ST_Distance_Spheroid
ST_Drivers()
DuckDB function ST_Drivers
ST_Dump()
DuckDB function ST_Dump
ST_EndPoint()
DuckDB function ST_EndPoint
ST_Envelope()
DuckDB function ST_Envelope
ST_Envelope_Agg()
DuckDB function ST_Envelope_Agg
ST_Equals()
DuckDB function ST_Equals
ST_Expand()
DuckDB function ST_Expand
ST_Extent()
DuckDB function ST_Extent
ST_Extent_Agg()
DuckDB function ST_Extent_Agg
ST_Extent_Approx()
DuckDB function ST_Extent_Approx
ST_ExteriorRing()
DuckDB function ST_ExteriorRing
ST_FlipCoordinates()
DuckDB function ST_FlipCoordinates
ST_Force2D()
DuckDB function ST_Force2D
ST_Force3DM()
DuckDB function ST_Force3DM
ST_Force3DZ()
DuckDB function ST_Force3DZ
ST_Force4D()
DuckDB function ST_Force4D
ST_GeneratePoints()
DuckDB function ST_GeneratePoints
ST_GeomFromGeoJSON()
DuckDB function ST_GeomFromGeoJSON
ST_GeomFromHEXEWKB()
DuckDB function ST_GeomFromHEXEWKB
ST_GeomFromHEXWKB()
DuckDB function ST_GeomFromHEXWKB
ST_GeomFromText()
DuckDB function ST_GeomFromText
ST_GeometryType()
DuckDB function ST_GeometryType
ST_HasM()
DuckDB function ST_HasM
ST_HasZ()
DuckDB function ST_HasZ
ST_Hilbert()
DuckDB function ST_Hilbert
ST_InteriorRingN()
DuckDB function ST_InteriorRingN
ST_InterpolatePoint()
DuckDB function ST_InterpolatePoint
ST_Intersection()
DuckDB function ST_Intersection
ST_Intersection_Agg()
DuckDB function ST_Intersection_Agg
ST_Intersects()
DuckDB function ST_Intersects
ST_IsClosed()
DuckDB function ST_IsClosed
ST_IsEmpty()
DuckDB function ST_IsEmpty
ST_IsRing()
DuckDB function ST_IsRing
ST_IsSimple()
DuckDB function ST_IsSimple
ST_IsValid()
DuckDB function ST_IsValid
ST_Length()
DuckDB function ST_Length
ST_Length_Spheroid()
DuckDB function ST_Length_Spheroid
ST_LineInterpolatePoint()
DuckDB function ST_LineInterpolatePoint
ST_LineInterpolatePoints()
DuckDB function ST_LineInterpolatePoints
ST_LineLocatePoint()
DuckDB function ST_LineLocatePoint
ST_LineMerge()
DuckDB function ST_LineMerge
ST_LineString2DFromWKB()
DuckDB function ST_LineString2DFromWKB
ST_LineSubstring()
DuckDB function ST_LineSubstring
ST_LocateAlong()
DuckDB function ST_LocateAlong
ST_LocateBetween()
DuckDB function ST_LocateBetween
ST_M()
DuckDB function ST_M
ST_MMax()
DuckDB function ST_MMax
ST_MMin()
DuckDB function ST_MMin
ST_MakeBox2D()
DuckDB function ST_MakeBox2D
ST_MakeEnvelope()
DuckDB function ST_MakeEnvelope
ST_MakeLine()
DuckDB function ST_MakeLine
ST_MakePoint()
DuckDB function ST_MakePoint
ST_MakePolygon()
DuckDB function ST_MakePolygon
ST_MakeValid()
DuckDB function ST_MakeValid
ST_MaximumInscribedCircle()
DuckDB function ST_MaximumInscribedCircle
ST_MemUnion_Agg()
DuckDB function ST_MemUnion_Agg
ST_MinimumRotatedRectangle()
DuckDB function ST_MinimumRotatedRectangle
ST_Multi()
DuckDB function ST_Multi
ST_NGeometries()
DuckDB function ST_NGeometries
ST_NInteriorRings()
DuckDB function ST_NInteriorRings
ST_NPoints()
DuckDB function ST_NPoints
ST_Node()
DuckDB function ST_Node
ST_Normalize()
DuckDB function ST_Normalize
ST_NumGeometries()
DuckDB function ST_NumGeometries
ST_NumInteriorRings()
DuckDB function ST_NumInteriorRings
ST_NumPoints()
DuckDB function ST_NumPoints
ST_Overlaps()
DuckDB function ST_Overlaps
ST_Perimeter()
DuckDB function ST_Perimeter
ST_Perimeter_Spheroid()
DuckDB function ST_Perimeter_Spheroid
ST_Point()
DuckDB function ST_Point
ST_Point2D()
DuckDB function ST_Point2D
ST_Point2DFromWKB()
DuckDB function ST_Point2DFromWKB
ST_Point3D()
DuckDB function ST_Point3D
ST_Point4D()
DuckDB function ST_Point4D
ST_PointN()
DuckDB function ST_PointN
ST_PointOnSurface()
DuckDB function ST_PointOnSurface
ST_Points()
DuckDB function ST_Points
ST_Polygon2DFromWKB()
DuckDB function ST_Polygon2DFromWKB
ST_Polygonize()
DuckDB function ST_Polygonize
ST_QuadKey()
DuckDB function ST_QuadKey
ST_Read()
DuckDB function ST_Read
ST_ReadOSM()
DuckDB function ST_ReadOSM
ST_ReadSHP()
DuckDB function ST_ReadSHP
ST_Read_Meta()
DuckDB function ST_Read_Meta
ST_ReducePrecision()
DuckDB function ST_ReducePrecision
ST_RemoveRepeatedPoints()
DuckDB function ST_RemoveRepeatedPoints
ST_Reverse()
DuckDB function ST_Reverse
ST_Rotate()
DuckDB function ST_Rotate
ST_RotateX()
DuckDB function ST_RotateX
ST_RotateY()
DuckDB function ST_RotateY
ST_RotateZ()
DuckDB function ST_RotateZ
ST_Scale()
DuckDB function ST_Scale
ST_ShortestLine()
DuckDB function ST_ShortestLine
ST_Simplify()
DuckDB function ST_Simplify
ST_SimplifyPreserveTopology()
DuckDB function ST_SimplifyPreserveTopology
ST_Snap()
DuckDB function ST_Snap
ST_StartPoint()
DuckDB function ST_StartPoint
ST_SymDifference()
DuckDB function ST_SymDifference
ST_TileEnvelope()
DuckDB function ST_TileEnvelope
ST_Touches()
DuckDB function ST_Touches
ST_TransScale()
DuckDB function ST_TransScale
ST_Transform()
DuckDB function ST_Transform
ST_Translate()
DuckDB function ST_Translate
ST_Union()
DuckDB function ST_Union
ST_Union_Agg()
DuckDB function ST_Union_Agg
ST_VoronoiDiagram()
DuckDB function ST_VoronoiDiagram
ST_Within()
DuckDB function ST_Within
ST_WithinProperly()
DuckDB function ST_WithinProperly
ST_X()
DuckDB function ST_X
ST_XMax()
DuckDB function ST_XMax
ST_XMin()
DuckDB function ST_XMin
ST_Y()
DuckDB function ST_Y
ST_YMax()
DuckDB function ST_YMax
ST_YMin()
DuckDB function ST_YMin
ST_Z()
DuckDB function ST_Z
ST_ZMFlag()
DuckDB function ST_ZMFlag
ST_ZMax()
DuckDB function ST_ZMax
ST_ZMin()
DuckDB function ST_ZMin
abs()
DuckDB function abs
acos()
DuckDB function acos
acosh()
DuckDB function acosh
add()
DuckDB function add
add_parquet_key()
DuckDB function add_parquet_key
age()
DuckDB function age
ago()
DuckDB function ago
alias()
DuckDB function alias
all_profiling_output()
DuckDB function all_profiling_output
`&`()
DuckDB function &
any_value()
DuckDB function any_value
approx_count_distinct()
DuckDB function approx_count_distinct
approx_quantile()
DuckDB function approx_quantile
approx_top_k()
DuckDB function approx_top_k
arg_max()
DuckDB function arg_max
arg_max_null()
DuckDB function arg_max_null
arg_max_nulls_last()
DuckDB function arg_max_nulls_last
arg_min()
DuckDB function arg_min
arg_min_null()
DuckDB function arg_min_null
arg_min_nulls_last()
DuckDB function arg_min_nulls_last
array_agg()
DuckDB function array_agg
array_append()
DuckDB function array_append
array_extract()
DuckDB function array_extract
array_pop_back()
DuckDB function array_pop_back
array_pop_front()
DuckDB function array_pop_front
array_prepend()
DuckDB function array_prepend
array_push_back()
DuckDB function array_push_back
array_push_front()
DuckDB function array_push_front
array_reverse()
DuckDB function array_reverse
array_to_json()
DuckDB function array_to_json
array_to_string()
DuckDB function array_to_string
array_to_string_comma_default()
DuckDB function array_to_string_comma_default
`->>`()
DuckDB function ->>
arrow_scan()
DuckDB function arrow_scan
arrow_scan_dumb()
DuckDB function arrow_scan_dumb
asin()
DuckDB function asin
asinh()
DuckDB function asinh
atan()
DuckDB function atan
atan2()
DuckDB function atan2
atanh()
DuckDB function atanh
avg()
DuckDB function avg
bit_and()
DuckDB function bit_and
bit_count()
DuckDB function bit_count
bit_or()
DuckDB function bit_or
bit_position()
DuckDB function bit_position
bit_xor()
DuckDB function bit_xor
bitstring()
DuckDB function bitstring
bitstring_agg()
DuckDB function bitstring_agg
bool_and()
DuckDB function bool_and
bool_or()
DuckDB function bool_or
broadcast()
DuckDB function broadcast
can_cast_implicitly()
DuckDB function can_cast_implicitly
cardinality()
DuckDB function cardinality
cast_to_type()
DuckDB function cast_to_type
cbrt()
DuckDB function cbrt
ceil()
DuckDB function ceil
century()
DuckDB function century
check_peg_parser()
DuckDB function check_peg_parser
checkpoint()
DuckDB function checkpoint
col_description()
DuckDB function col_description
collations()
DuckDB function collations
combine()
DuckDB function combine
concat()
DuckDB function concat
constant_or_null()
DuckDB function constant_or_null
copy_database()
DuckDB function copy_database
copy_dir()
DuckDB function copy_dir
corr()
DuckDB function corr
cos()
DuckDB function cos
cosh()
DuckDB function cosh
cot()
DuckDB function cot
count()
DuckDB function count
count_if()
DuckDB function count_if
count_star()
DuckDB function count_star
covar_pop()
DuckDB function covar_pop
covar_samp()
DuckDB function covar_samp
create_fts_index()
DuckDB function create_fts_index
create_sort_key()
DuckDB function create_sort_key
cume_dist()
DuckDB function cume_dist
current_catalog()
DuckDB function current_catalog
current_connection_id()
DuckDB function current_connection_id
current_database()
DuckDB function current_database
current_date()
DuckDB function current_date
current_localtime()
DuckDB function current_localtime
current_localtimestamp()
DuckDB function current_localtimestamp
current_query()
DuckDB function current_query
current_query_id()
DuckDB function current_query_id
current_role()
DuckDB function current_role
current_schema()
DuckDB function current_schema
current_schemas()
DuckDB function current_schemas
current_setting()
DuckDB function current_setting
current_transaction_id()
DuckDB function current_transaction_id
current_user()
DuckDB function current_user
currval()
DuckDB function currval
database_list()
DuckDB function database_list
database_size()
DuckDB function database_size
date_add()
DuckDB function date_add
date_diff()
DuckDB function date_diff
date_part()
DuckDB function date_part
date_sub()
DuckDB function date_sub
date_trunc()
DuckDB function date_trunc
day()
DuckDB function day
dayname()
DuckDB function dayname
dayofmonth()
DuckDB function dayofmonth
dayofweek()
DuckDB function dayofweek
dayofyear()
DuckDB function dayofyear
days_in_month()
DuckDB function days_in_month
dbgen()
DuckDB function dbgen
dd
DuckDB functions
decade()
DuckDB function decade
degrees()
DuckDB function degrees
delta_domain_metadata()
DuckDB function delta_domain_metadata
delta_filter_pushdown_log()
DuckDB function delta_filter_pushdown_log
delta_filter_pushdown_log_tpcds()
DuckDB function delta_filter_pushdown_log_tpcds
delta_get_transaction_version()
DuckDB function delta_get_transaction_version
delta_list_files()
DuckDB function delta_list_files
delta_scan()
DuckDB function delta_scan
delta_set_transaction_version()
DuckDB function delta_set_transaction_version
dense_rank()
DuckDB function dense_rank
disable_checkpoint_on_shutdown()
DuckDB function disable_checkpoint_on_shutdown
disable_logging()
DuckDB function disable_logging
disable_object_cache()
DuckDB function disable_object_cache
disable_optimizer()
DuckDB function disable_optimizer
disable_peg_parser()
DuckDB function disable_peg_parser
disable_print_progress_bar()
DuckDB function disable_print_progress_bar
disable_profile()
DuckDB function disable_profile
disable_profiling()
DuckDB function disable_profiling
disable_progress_bar()
DuckDB function disable_progress_bar
disable_verification()
DuckDB function disable_verification
disable_verify_external()
DuckDB function disable_verify_external
disable_verify_fetch_row()
DuckDB function disable_verify_fetch_row
disable_verify_parallelism()
DuckDB function disable_verify_parallelism
disable_verify_serializer()
DuckDB function disable_verify_serializer
divide()
DuckDB function divide
drop_fts_index()
DuckDB function drop_fts_index
dsdgen()
DuckDB function dsdgen
duckdb_approx_database_count()
DuckDB function duckdb_approx_database_count
duckdb_columns()
DuckDB function duckdb_columns
duckdb_connection_count()
DuckDB function duckdb_connection_count
duckdb_constraints()
DuckDB function duckdb_constraints
duckdb_coordinate_systems()
DuckDB function duckdb_coordinate_systems
duckdb_databases()
DuckDB function duckdb_databases
duckdb_dependencies()
DuckDB function duckdb_dependencies
duckdb_extensions()
DuckDB function duckdb_extensions
duckdb_external_file_cache()
DuckDB function duckdb_external_file_cache
duckdb_functions()
DuckDB function duckdb_functions
duckdb_indexes()
DuckDB function duckdb_indexes
duckdb_keywords()
DuckDB function duckdb_keywords
duckdb_log_contexts()
DuckDB function duckdb_log_contexts
duckdb_logs()
DuckDB function duckdb_logs
duckdb_logs_parsed()
DuckDB function duckdb_logs_parsed
duckdb_memory()
DuckDB function duckdb_memory
duckdb_optimizers()
DuckDB function duckdb_optimizers
duckdb_prepared_statements()
DuckDB function duckdb_prepared_statements
duckdb_profiling_settings()
DuckDB function duckdb_profiling_settings
duckdb_schemas()
DuckDB function duckdb_schemas
duckdb_secret_types()
DuckDB function duckdb_secret_types
duckdb_secrets()
DuckDB function duckdb_secrets
duckdb_sequences()
DuckDB function duckdb_sequences
duckdb_settings()
DuckDB function duckdb_settings
duckdb_table_sample()
DuckDB function duckdb_table_sample
duckdb_tables()
DuckDB function duckdb_tables
duckdb_temporary_files()
DuckDB function duckdb_temporary_files
duckdb_types()
DuckDB function duckdb_types
duckdb_variables()
DuckDB function duckdb_variables
duckdb_views()
DuckDB function duckdb_views
ducklake_add_data_files()
DuckDB function ducklake_add_data_files
ducklake_cleanup_old_files()
DuckDB function ducklake_cleanup_old_files
ducklake_commit()
DuckDB function ducklake_commit
ducklake_current_snapshot()
DuckDB function ducklake_current_snapshot
ducklake_delete_orphaned_files()
DuckDB function ducklake_delete_orphaned_files
ducklake_expire_snapshots()
DuckDB function ducklake_expire_snapshots
ducklake_flush_inlined_data()
DuckDB function ducklake_flush_inlined_data
ducklake_last_committed_snapshot()
DuckDB function ducklake_last_committed_snapshot
ducklake_list_files()
DuckDB function ducklake_list_files
ducklake_merge_adjacent_files()
DuckDB function ducklake_merge_adjacent_files
ducklake_options()
DuckDB function ducklake_options
ducklake_rewrite_data_files()
DuckDB function ducklake_rewrite_data_files
ducklake_scan()
DuckDB function ducklake_scan
ducklake_set_commit_message()
DuckDB function ducklake_set_commit_message
ducklake_set_option()
DuckDB function ducklake_set_option
ducklake_settings()
DuckDB function ducklake_settings
ducklake_snapshots()
DuckDB function ducklake_snapshots
ducklake_table_changes()
DuckDB function ducklake_table_changes
ducklake_table_deletions()
DuckDB function ducklake_table_deletions
ducklake_table_info()
DuckDB function ducklake_table_info
ducklake_table_insertions()
DuckDB function ducklake_table_insertions
enable_checkpoint_on_shutdown()
DuckDB function enable_checkpoint_on_shutdown
enable_logging()
DuckDB function enable_logging
enable_object_cache()
DuckDB function enable_object_cache
enable_optimizer()
DuckDB function enable_optimizer
enable_peg_parser()
DuckDB function enable_peg_parser
enable_print_progress_bar()
DuckDB function enable_print_progress_bar
enable_profile()
DuckDB function enable_profile
enable_profiling()
DuckDB function enable_profiling
enable_progress_bar()
DuckDB function enable_progress_bar
enable_verification()
DuckDB function enable_verification
entropy()
DuckDB function entropy
enum_code()
DuckDB function enum_code
enum_first()
DuckDB function enum_first
enum_last()
DuckDB function enum_last
enum_range()
DuckDB function enum_range
enum_range_boundary()
DuckDB function enum_range_boundary
epoch()
DuckDB function epoch
epoch_ms()
DuckDB function epoch_ms
epoch_ns()
DuckDB function epoch_ns
epoch_us()
DuckDB function epoch_us
equi_width_bins()
DuckDB function equi_width_bins
era()
DuckDB function era
error()
DuckDB function error
even()
DuckDB function even
excel_text()
DuckDB function excel_text
exp()
DuckDB function exp
extension_versions()
DuckDB function extension_versions
factorial()
DuckDB function factorial
family()
DuckDB function family
favg()
DuckDB function favg
fdiv()
DuckDB function fdiv
fill()
DuckDB function fill
finalize()
DuckDB function finalize
first()
DuckDB function first
first_value()
DuckDB function first_value
floor()
DuckDB function floor
fmod()
DuckDB function fmod
force_checkpoint()
DuckDB function force_checkpoint
format_pg_type()
DuckDB function format_pg_type
format_type()
DuckDB function format_type
from_json()
DuckDB function from_json
from_json_strict()
DuckDB function from_json_strict
functions()
DuckDB function functions
gamma()
DuckDB function gamma
generate_subscripts()
DuckDB function generate_subscripts
geomean()
DuckDB function geomean
geometric_mean()
DuckDB function geometric_mean
get_bit()
DuckDB function get_bit
get_block_size()
DuckDB function get_block_size
get_current_time()
DuckDB function get_current_time
get_current_timestamp()
DuckDB function get_current_timestamp
get_delta_test_expression()
DuckDB function get_delta_test_expression
get_type()
DuckDB function get_type
get_ui_url()
DuckDB function get_ui_url
getvariable()
DuckDB function getvariable
glob()
DuckDB function glob
`>>=`()
DuckDB function >>=
`>>`()
DuckDB function >>
greatest_common_divisor()
DuckDB function greatest_common_divisor
has_any_column_privilege()
DuckDB function has_any_column_privilege
has_column_privilege()
DuckDB function has_column_privilege
has_database_privilege()
DuckDB function has_database_privilege
has_foreign_data_wrapper_privilege()
DuckDB function has_foreign_data_wrapper_privilege
has_function_privilege()
DuckDB function has_function_privilege
has_language_privilege()
DuckDB function has_language_privilege
has_schema_privilege()
DuckDB function has_schema_privilege
has_sequence_privilege()
DuckDB function has_sequence_privilege
has_server_privilege()
DuckDB function has_server_privilege
has_table_privilege()
DuckDB function has_table_privilege
has_tablespace_privilege()
DuckDB function has_tablespace_privilege
hex()
DuckDB function hex
histogram()
DuckDB function histogram
histogram_exact()
DuckDB function histogram_exact
histogram_values()
DuckDB function histogram_values
hnsw_compact_index()
DuckDB function hnsw_compact_index
hnsw_index_scan()
DuckDB function hnsw_index_scan
host()
DuckDB function host
hour()
DuckDB function hour
html_escape()
DuckDB function html_escape
html_unescape()
DuckDB function html_unescape
iceberg_bucket()
DuckDB function iceberg_bucket
iceberg_column_stats()
DuckDB function iceberg_column_stats
iceberg_load_table_response()
DuckDB function iceberg_load_table_response
iceberg_metadata()
DuckDB function iceberg_metadata
iceberg_partition_stats()
DuckDB function iceberg_partition_stats
iceberg_scan()
DuckDB function iceberg_scan
iceberg_schema_properties()
DuckDB function iceberg_schema_properties
iceberg_snapshots()
DuckDB function iceberg_snapshots
iceberg_table_properties()
DuckDB function iceberg_table_properties
iceberg_to_ducklake()
DuckDB function iceberg_to_ducklake
iceberg_truncate()
DuckDB function iceberg_truncate
iceberg_verify_equality_deletes()
DuckDB function iceberg_verify_equality_deletes
icu_calendar_names()
DuckDB function icu_calendar_names
icu_collate_af()
DuckDB function icu_collate_af
icu_collate_am()
DuckDB function icu_collate_am
icu_collate_ar()
DuckDB function icu_collate_ar
icu_collate_ar_sa()
DuckDB function icu_collate_ar_sa
icu_collate_as()
DuckDB function icu_collate_as
icu_collate_az()
DuckDB function icu_collate_az
icu_collate_be()
DuckDB function icu_collate_be
icu_collate_bg()
DuckDB function icu_collate_bg
icu_collate_bn()
DuckDB function icu_collate_bn
icu_collate_bo()
DuckDB function icu_collate_bo
icu_collate_br()
DuckDB function icu_collate_br
icu_collate_bs()
DuckDB function icu_collate_bs
icu_collate_ca()
DuckDB function icu_collate_ca
icu_collate_ceb()
DuckDB function icu_collate_ceb
icu_collate_chr()
DuckDB function icu_collate_chr
icu_collate_cs()
DuckDB function icu_collate_cs
icu_collate_cy()
DuckDB function icu_collate_cy
icu_collate_da()
DuckDB function icu_collate_da
icu_collate_de()
DuckDB function icu_collate_de
icu_collate_de_at()
DuckDB function icu_collate_de_at
icu_collate_dsb()
DuckDB function icu_collate_dsb
icu_collate_dz()
DuckDB function icu_collate_dz
icu_collate_ee()
DuckDB function icu_collate_ee
icu_collate_el()
DuckDB function icu_collate_el
icu_collate_en()
DuckDB function icu_collate_en
icu_collate_en_us()
DuckDB function icu_collate_en_us
icu_collate_eo()
DuckDB function icu_collate_eo
icu_collate_es()
DuckDB function icu_collate_es
icu_collate_et()
DuckDB function icu_collate_et
icu_collate_fa()
DuckDB function icu_collate_fa
icu_collate_fa_af()
DuckDB function icu_collate_fa_af
icu_collate_ff()
DuckDB function icu_collate_ff
icu_collate_fi()
DuckDB function icu_collate_fi
icu_collate_fil()
DuckDB function icu_collate_fil
icu_collate_fo()
DuckDB function icu_collate_fo
icu_collate_fr()
DuckDB function icu_collate_fr
icu_collate_fr_ca()
DuckDB function icu_collate_fr_ca
icu_collate_fy()
DuckDB function icu_collate_fy
icu_collate_ga()
DuckDB function icu_collate_ga
icu_collate_gl()
DuckDB function icu_collate_gl
icu_collate_gu()
DuckDB function icu_collate_gu
icu_collate_ha()
DuckDB function icu_collate_ha
icu_collate_haw()
DuckDB function icu_collate_haw
icu_collate_he()
DuckDB function icu_collate_he
icu_collate_he_il()
DuckDB function icu_collate_he_il
icu_collate_hi()
DuckDB function icu_collate_hi
icu_collate_hr()
DuckDB function icu_collate_hr
icu_collate_hsb()
DuckDB function icu_collate_hsb
icu_collate_hu()
DuckDB function icu_collate_hu
icu_collate_hy()
DuckDB function icu_collate_hy
icu_collate_id()
DuckDB function icu_collate_id
icu_collate_id_id()
DuckDB function icu_collate_id_id
icu_collate_ig()
DuckDB function icu_collate_ig
icu_collate_is()
DuckDB function icu_collate_is
icu_collate_it()
DuckDB function icu_collate_it
icu_collate_ja()
DuckDB function icu_collate_ja
icu_collate_ka()
DuckDB function icu_collate_ka
icu_collate_kk()
DuckDB function icu_collate_kk
icu_collate_kl()
DuckDB function icu_collate_kl
icu_collate_km()
DuckDB function icu_collate_km
icu_collate_kn()
DuckDB function icu_collate_kn
icu_collate_ko()
DuckDB function icu_collate_ko
icu_collate_kok()
DuckDB function icu_collate_kok
icu_collate_ku()
DuckDB function icu_collate_ku
icu_collate_ky()
DuckDB function icu_collate_ky
icu_collate_lb()
DuckDB function icu_collate_lb
icu_collate_lij()
DuckDB function icu_collate_lij
icu_collate_lkt()
DuckDB function icu_collate_lkt
icu_collate_ln()
DuckDB function icu_collate_ln
icu_collate_lo()
DuckDB function icu_collate_lo
icu_collate_lt()
DuckDB function icu_collate_lt
icu_collate_lv()
DuckDB function icu_collate_lv
icu_collate_mk()
DuckDB function icu_collate_mk
icu_collate_ml()
DuckDB function icu_collate_ml
icu_collate_mn()
DuckDB function icu_collate_mn
icu_collate_mr()
DuckDB function icu_collate_mr
icu_collate_ms()
DuckDB function icu_collate_ms
icu_collate_mt()
DuckDB function icu_collate_mt
icu_collate_my()
DuckDB function icu_collate_my
icu_collate_nb()
DuckDB function icu_collate_nb
icu_collate_nb_no()
DuckDB function icu_collate_nb_no
icu_collate_ne()
DuckDB function icu_collate_ne
icu_collate_nl()
DuckDB function icu_collate_nl
icu_collate_nn()
DuckDB function icu_collate_nn
icu_collate_noaccent()
DuckDB function icu_collate_noaccent
icu_collate_nso()
DuckDB function icu_collate_nso
icu_collate_om()
DuckDB function icu_collate_om
icu_collate_or()
DuckDB function icu_collate_or
icu_collate_pa()
DuckDB function icu_collate_pa
icu_collate_pa_in()
DuckDB function icu_collate_pa_in
icu_collate_pl()
DuckDB function icu_collate_pl
icu_collate_ps()
DuckDB function icu_collate_ps
icu_collate_pt()
DuckDB function icu_collate_pt
icu_collate_ro()
DuckDB function icu_collate_ro
icu_collate_ru()
DuckDB function icu_collate_ru
icu_collate_sa()
DuckDB function icu_collate_sa
icu_collate_se()
DuckDB function icu_collate_se
icu_collate_si()
DuckDB function icu_collate_si
icu_collate_sk()
DuckDB function icu_collate_sk
icu_collate_sl()
DuckDB function icu_collate_sl
icu_collate_smn()
DuckDB function icu_collate_smn
icu_collate_sq()
DuckDB function icu_collate_sq
icu_collate_sr()
DuckDB function icu_collate_sr
icu_collate_sr_ba()
DuckDB function icu_collate_sr_ba
icu_collate_sr_me()
DuckDB function icu_collate_sr_me
icu_collate_sr_rs()
DuckDB function icu_collate_sr_rs
icu_collate_st()
DuckDB function icu_collate_st
icu_collate_sv()
DuckDB function icu_collate_sv
icu_collate_sw()
DuckDB function icu_collate_sw
icu_collate_ta()
DuckDB function icu_collate_ta
icu_collate_te()
DuckDB function icu_collate_te
icu_collate_th()
DuckDB function icu_collate_th
icu_collate_tk()
DuckDB function icu_collate_tk
icu_collate_tn()
DuckDB function icu_collate_tn
icu_collate_to()
DuckDB function icu_collate_to
icu_collate_tr()
DuckDB function icu_collate_tr
icu_collate_ug()
DuckDB function icu_collate_ug
icu_collate_uk()
DuckDB function icu_collate_uk
icu_collate_ur()
DuckDB function icu_collate_ur
icu_collate_uz()
DuckDB function icu_collate_uz
icu_collate_vi()
DuckDB function icu_collate_vi
icu_collate_wae()
DuckDB function icu_collate_wae
icu_collate_wo()
DuckDB function icu_collate_wo
icu_collate_xh()
DuckDB function icu_collate_xh
icu_collate_yi()
DuckDB function icu_collate_yi
icu_collate_yo()
DuckDB function icu_collate_yo
icu_collate_yue()
DuckDB function icu_collate_yue
icu_collate_yue_cn()
DuckDB function icu_collate_yue_cn
icu_collate_zh()
DuckDB function icu_collate_zh
icu_collate_zh_cn()
DuckDB function icu_collate_zh_cn
icu_collate_zh_hk()
DuckDB function icu_collate_zh_hk
icu_collate_zh_mo()
DuckDB function icu_collate_zh_mo
icu_collate_zh_sg()
DuckDB function icu_collate_zh_sg
icu_collate_zh_tw()
DuckDB function icu_collate_zh_tw
icu_collate_zu()
DuckDB function icu_collate_zu
icu_sort_key()
DuckDB function icu_sort_key
import_database()
DuckDB function import_database
in_search_path()
DuckDB function in_search_path
inet_client_addr()
DuckDB function inet_client_addr
inet_client_port()
DuckDB function inet_client_port
inet_server_addr()
DuckDB function inet_server_addr
inet_server_port()
DuckDB function inet_server_port
is_histogram_other_bin()
DuckDB function is_histogram_other_bin
isfinite()
DuckDB function isfinite
isinf()
DuckDB function isinf
isnan()
DuckDB function isnan
isodow()
DuckDB function isodow
isoyear()
DuckDB function isoyear
json()
DuckDB function json
json_array()
DuckDB function json_array
json_array_length()
DuckDB function json_array_length
json_contains()
DuckDB function json_contains
json_deserialize_sql()
DuckDB function json_deserialize_sql
json_each()
DuckDB function json_each
json_execute_serialized_sql()
DuckDB function json_execute_serialized_sql
json_exists()
DuckDB function json_exists
json_extract()
DuckDB function json_extract
json_extract_path()
DuckDB function json_extract_path
json_extract_path_text()
DuckDB function json_extract_path_text
json_extract_string()
DuckDB function json_extract_string
json_group_array()
DuckDB function json_group_array
json_group_object()
DuckDB function json_group_object
json_group_structure()
DuckDB function json_group_structure
json_keys()
DuckDB function json_keys
json_merge_patch()
DuckDB function json_merge_patch
json_object()
DuckDB function json_object
json_pretty()
DuckDB function json_pretty
json_quote()
DuckDB function json_quote
json_serialize_plan()
DuckDB function json_serialize_plan
json_serialize_sql()
DuckDB function json_serialize_sql
json_structure()
DuckDB function json_structure
json_transform()
DuckDB function json_transform
json_transform_strict()
DuckDB function json_transform_strict
json_tree()
DuckDB function json_tree
json_type()
DuckDB function json_type
json_valid()
DuckDB function json_valid
json_value()
DuckDB function json_value
julian()
DuckDB function julian
kahan_sum()
DuckDB function kahan_sum
kurtosis()
DuckDB function kurtosis
kurtosis_pop()
DuckDB function kurtosis_pop
lag()
DuckDB function lag
lance_fts()
DuckDB function lance_fts
lance_hybrid_search()
DuckDB function lance_hybrid_search
lance_vector_search()
DuckDB function lance_vector_search
last()
DuckDB function last
last_day()
DuckDB function last_day
last_value()
DuckDB function last_value
lead()
DuckDB function lead
least_common_multiple()
DuckDB function least_common_multiple
len()
DuckDB function len
`<<=`()
DuckDB function <<=
`<<`()
DuckDB function <<
lgamma()
DuckDB function lgamma
list_any_value()
DuckDB function list_any_value
list_append()
DuckDB function list_append
list_approx_count_distinct()
DuckDB function list_approx_count_distinct
list_avg()
DuckDB function list_avg
list_bit_and()
DuckDB function list_bit_and
list_bit_or()
DuckDB function list_bit_or
list_bit_xor()
DuckDB function list_bit_xor
list_bool_and()
DuckDB function list_bool_and
list_bool_or()
DuckDB function list_bool_or
list_count()
DuckDB function list_count
list_entropy()
DuckDB function list_entropy
list_first()
DuckDB function list_first
list_histogram()
DuckDB function list_histogram
list_kurtosis()
DuckDB function list_kurtosis
list_kurtosis_pop()
DuckDB function list_kurtosis_pop
list_last()
DuckDB function list_last
list_mad()
DuckDB function list_mad
list_max()
DuckDB function list_max
list_median()
DuckDB function list_median
list_min()
DuckDB function list_min
list_mode()
DuckDB function list_mode
list_prepend()
DuckDB function list_prepend
list_product()
DuckDB function list_product
list_reverse()
DuckDB function list_reverse
list_sem()
DuckDB function list_sem
list_skewness()
DuckDB function list_skewness
list_slice()
DuckDB function list_slice
list_stddev_pop()
DuckDB function list_stddev_pop
list_stddev_samp()
DuckDB function list_stddev_samp
list_string_agg()
DuckDB function list_string_agg
list_sum()
DuckDB function list_sum
list_var_pop()
DuckDB function list_var_pop
list_var_samp()
DuckDB function list_var_samp
ln()
DuckDB function ln
load_aws_credentials()
DuckDB function load_aws_credentials
log()
DuckDB function log
log10()
DuckDB function log10
log2()
DuckDB function log2
mad()
DuckDB function mad
make_date()
DuckDB function make_date
make_time()
DuckDB function make_time
make_timestamp()
DuckDB function make_timestamp
make_timestamp_ms()
DuckDB function make_timestamp_ms
make_timestamp_ns()
DuckDB function make_timestamp_ns
make_timestamptz()
DuckDB function make_timestamptz
make_type()
DuckDB function make_type
map()
DuckDB function map
map_concat()
DuckDB function map_concat
map_contains()
DuckDB function map_contains
map_contains_entry()
DuckDB function map_contains_entry
map_contains_value()
DuckDB function map_contains_value
map_entries()
DuckDB function map_entries
map_extract()
DuckDB function map_extract
map_extract_value()
DuckDB function map_extract_value
map_from_entries()
DuckDB function map_from_entries
map_keys()
DuckDB function map_keys
map_to_pg_oid()
DuckDB function map_to_pg_oid
map_values()
DuckDB function map_values
max()
DuckDB function max
md5_number_lower()
DuckDB function md5_number_lower
md5_number_upper()
DuckDB function md5_number_upper
median()
DuckDB function median
metadata_info()
DuckDB function metadata_info
microsecond()
DuckDB function microsecond
millennium()
DuckDB function millennium
millisecond()
DuckDB function millisecond
min()
DuckDB function min
minute()
DuckDB function minute
mod()
DuckDB function mod
mode()
DuckDB function mode
month()
DuckDB function month
monthname()
DuckDB function monthname
multiply()
DuckDB function multiply
murmur3_32()
DuckDB function murmur3_32
mysql_clear_cache()
DuckDB function mysql_clear_cache
mysql_debug_execution_plan()
DuckDB function mysql_debug_execution_plan
mysql_execute()
DuckDB function mysql_execute
mysql_explain_federated()
DuckDB function mysql_explain_federated
mysql_query()
DuckDB function mysql_query
nanosecond()
DuckDB function nanosecond
netmask()
DuckDB function netmask
network()
DuckDB function network
nextafter()
DuckDB function nextafter
nextval()
DuckDB function nextval
normalized_interval()
DuckDB function normalized_interval
`!~~*`()
DuckDB function !~~*
`!~~`()
DuckDB function !~~
nth_value()
DuckDB function nth_value
ntile()
DuckDB function ntile
nullif()
DuckDB function nullif
obj_description()
DuckDB function obj_description
octet_length()
DuckDB function octet_length
`|`
DuckDB function |
parquet_bloom_probe()
DuckDB function parquet_bloom_probe
parquet_file_metadata()
DuckDB function parquet_file_metadata
parquet_full_metadata()
DuckDB function parquet_full_metadata
parquet_kv_metadata()
DuckDB function parquet_kv_metadata
parquet_metadata()
DuckDB function parquet_metadata
parquet_scan()
DuckDB function parquet_scan
parquet_schema()
DuckDB function parquet_schema
parse_delta_filter_logline()
DuckDB function parse_delta_filter_logline
parse_duckdb_log_message()
DuckDB function parse_duckdb_log_message
percent_rank()
DuckDB function percent_rank
pg_clear_cache()
DuckDB function pg_clear_cache
pg_collation_is_visible()
DuckDB function pg_collation_is_visible
pg_conf_load_time()
DuckDB function pg_conf_load_time
pg_conversion_is_visible()
DuckDB function pg_conversion_is_visible
pg_function_is_visible()
DuckDB function pg_function_is_visible
pg_get_constraintdef()
DuckDB function pg_get_constraintdef
pg_get_expr()
DuckDB function pg_get_expr
pg_get_viewdef()
DuckDB function pg_get_viewdef
pg_has_role()
DuckDB function pg_has_role
pg_is_other_temp_schema()
DuckDB function pg_is_other_temp_schema
pg_my_temp_schema()
DuckDB function pg_my_temp_schema
pg_opclass_is_visible()
DuckDB function pg_opclass_is_visible
pg_operator_is_visible()
DuckDB function pg_operator_is_visible
pg_opfamily_is_visible()
DuckDB function pg_opfamily_is_visible
pg_postmaster_start_time()
DuckDB function pg_postmaster_start_time
pg_size_pretty()
DuckDB function pg_size_pretty
pg_sleep()
DuckDB function pg_sleep
pg_table_is_visible()
DuckDB function pg_table_is_visible
pg_timezone_names()
DuckDB function pg_timezone_names
pg_ts_config_is_visible()
DuckDB function pg_ts_config_is_visible
pg_ts_dict_is_visible()
DuckDB function pg_ts_dict_is_visible
pg_ts_parser_is_visible()
DuckDB function pg_ts_parser_is_visible
pg_ts_template_is_visible()
DuckDB function pg_ts_template_is_visible
pg_type_is_visible()
DuckDB function pg_type_is_visible
pg_typeof()
DuckDB function pg_typeof
pi()
DuckDB function pi
platform()
DuckDB function platform
postgres_attach()
DuckDB function postgres_attach
postgres_configure_pool()
DuckDB function postgres_configure_pool
postgres_execute()
DuckDB function postgres_execute
postgres_hstore_get()
DuckDB function postgres_hstore_get
postgres_hstore_to_json()
DuckDB function postgres_hstore_to_json
postgres_query()
DuckDB function postgres_query
postgres_scan()
DuckDB function postgres_scan
postgres_scan_pushdown()
DuckDB function postgres_scan_pushdown
pow()
DuckDB function pow
pragma_collations()
DuckDB function pragma_collations
pragma_database_size()
DuckDB function pragma_database_size
pragma_hnsw_index_info()
DuckDB function pragma_hnsw_index_info
pragma_metadata_info()
DuckDB function pragma_metadata_info
pragma_platform()
DuckDB function pragma_platform
pragma_rtree_index_info()
DuckDB function pragma_rtree_index_info
pragma_show()
DuckDB function pragma_show
pragma_storage_info()
DuckDB function pragma_storage_info
pragma_table_info()
DuckDB function pragma_table_info
pragma_user_agent()
DuckDB function pragma_user_agent
pragma_version()
DuckDB function pragma_version
product()
DuckDB function product
quack_active_connections()
DuckDB function quack_active_connections
quack_check_token()
DuckDB function quack_check_token
quack_clear_cache()
DuckDB function quack_clear_cache
quack_identify()
DuckDB function quack_identify
quack_nop_authorization()
DuckDB function quack_nop_authorization
quack_query()
DuckDB function quack_query
quack_query_by_name()
DuckDB function quack_query_by_name
quack_serve()
DuckDB function quack_serve
quack_server_list()
DuckDB function quack_server_list
quack_stop()
DuckDB function quack_stop
quack_uri_parser()
DuckDB function quack_uri_parser
quantile_cont()
DuckDB function quantile_cont
quantile_disc()
DuckDB function quantile_disc
quarter()
DuckDB function quarter
query()
DuckDB function query
query_table()
DuckDB function query_table
r_dataframe_scan()
DuckDB function r_dataframe_scan
radians()
DuckDB function radians
random()
DuckDB function random
rank()
DuckDB function rank
rank_dense()
DuckDB function rank_dense
read_avro()
DuckDB function read_avro
read_blob()
DuckDB function read_blob
read_csv()
DuckDB function read_csv
read_csv_auto()
DuckDB function read_csv_auto
read_duckdb()
DuckDB function read_duckdb
read_json()
DuckDB function read_json
read_json_auto()
DuckDB function read_json_auto
read_json_objects()
DuckDB function read_json_objects
read_json_objects_auto()
DuckDB function read_json_objects_auto
read_ndjson()
DuckDB function read_ndjson
read_ndjson_auto()
DuckDB function read_ndjson_auto
read_ndjson_objects()
DuckDB function read_ndjson_objects
read_parquet()
DuckDB function read_parquet
read_postgres_binary()
DuckDB function read_postgres_binary
read_text()
DuckDB function read_text
read_vortex()
DuckDB function read_vortex
read_xlsx()
DuckDB function read_xlsx
regexp_split_to_table()
DuckDB function regexp_split_to_table
regr_avgx()
DuckDB function regr_avgx
regr_avgy()
DuckDB function regr_avgy
regr_count()
DuckDB function regr_count
regr_intercept()
DuckDB function regr_intercept
regr_r2()
DuckDB function regr_r2
regr_slope()
DuckDB function regr_slope
regr_sxx()
DuckDB function regr_sxx
regr_sxy()
DuckDB function regr_sxy
regr_syy()
DuckDB function regr_syy
remap_struct()
DuckDB function remap_struct
remove_iceberg_schema_properties()
DuckDB function remove_iceberg_schema_properties
remove_iceberg_table_properties()
DuckDB function remove_iceberg_table_properties
repeat_row()
DuckDB function repeat_row
replace_type()
DuckDB function replace_type
reservoir_quantile()
DuckDB function reservoir_quantile
round()
DuckDB function round
round_even()
DuckDB function round_even
roundbankers()
DuckDB function roundbankers
row()
DuckDB function row
row_number()
DuckDB function row_number
row_to_json()
DuckDB function row_to_json
rtree_index_dump()
DuckDB function rtree_index_dump
rtree_index_scan()
DuckDB function rtree_index_scan
second()
DuckDB function second
sem()
DuckDB function sem
seq_scan()
DuckDB function seq_scan
session_user()
DuckDB function session_user
set_bit()
DuckDB function set_bit
set_iceberg_schema_properties()
DuckDB function set_iceberg_schema_properties
set_iceberg_table_properties()
DuckDB function set_iceberg_table_properties
setseed()
DuckDB function setseed
shapefile_meta()
DuckDB function shapefile_meta
shobj_description()
DuckDB function shobj_description
show()
DuckDB function show
show_databases()
DuckDB function show_databases
show_tables()
DuckDB function show_tables
show_tables_expanded()
DuckDB function show_tables_expanded
sign()
DuckDB function sign
signbit()
DuckDB function signbit
sin()
DuckDB function sin
sinh()
DuckDB function sinh
skewness()
DuckDB function skewness
`/`
DuckDB function /
sleep_ms()
DuckDB function sleep_ms
sniff_csv()
DuckDB function sniff_csv
split_part()
DuckDB function split_part
sql_auto_complete()
DuckDB function sql_auto_complete
sqlite_attach()
DuckDB function sqlite_attach
sqlite_query()
DuckDB function sqlite_query
sqlite_scan()
DuckDB function sqlite_scan
sqrt()
DuckDB function sqrt
st_setcrs()
DuckDB function st_setcrs
start_ui()
DuckDB function start_ui
start_ui_server()
DuckDB function start_ui_server
stats()
DuckDB function stats
stddev_pop()
DuckDB function stddev_pop
stddev_samp()
DuckDB function stddev_samp
stem()
DuckDB function stem
stop_ui_server()
DuckDB function stop_ui_server
storage_info()
DuckDB function storage_info
strftime()
DuckDB function strftime
string_agg()
DuckDB function string_agg
strptime()
DuckDB function strptime
struct_concat()
DuckDB function struct_concat
struct_contains()
DuckDB function struct_contains
struct_extract()
DuckDB function struct_extract
struct_extract_at()
DuckDB function struct_extract_at
struct_insert()
DuckDB function struct_insert
struct_keys()
DuckDB function struct_keys
struct_pack()
DuckDB function struct_pack
struct_position()
DuckDB function struct_position
struct_update()
DuckDB function struct_update
struct_values()
DuckDB function struct_values
subtract()
DuckDB function subtract
sum()
DuckDB function sum
sum_no_overflow()
DuckDB function sum_no_overflow
summary()
DuckDB function summary
switch()
DuckDB function switch
table_info()
DuckDB function table_info
tan()
DuckDB function tan
tanh()
DuckDB function tanh
test_all_types()
DuckDB function test_all_types
test_vector_types()
DuckDB function test_vector_types
text()
DuckDB function text
time_bucket()
DuckDB function time_bucket
timetz_byte_comparable()
DuckDB function timetz_byte_comparable
timezone()
DuckDB function timezone
timezone_hour()
DuckDB function timezone_hour
timezone_minute()
DuckDB function timezone_minute
to_centuries()
DuckDB function to_centuries
to_days()
DuckDB function to_days
to_decades()
DuckDB function to_decades
to_hours()
DuckDB function to_hours
to_json()
DuckDB function to_json
to_microseconds()
DuckDB function to_microseconds
to_millennia()
DuckDB function to_millennia
to_milliseconds()
DuckDB function to_milliseconds
to_minutes()
DuckDB function to_minutes
to_months()
DuckDB function to_months
to_quarters()
DuckDB function to_quarters
to_seconds()
DuckDB function to_seconds
to_timestamp()
DuckDB function to_timestamp
to_weeks()
DuckDB function to_weeks
to_years()
DuckDB function to_years
today()
DuckDB function today
tpcds()
DuckDB function tpcds
tpcds_answers()
DuckDB function tpcds_answers
tpcds_queries()
DuckDB function tpcds_queries
tpch()
DuckDB function tpch
tpch_answers()
DuckDB function tpch_answers
tpch_queries()
DuckDB function tpch_queries
trunc()
DuckDB function trunc
truncate_duckdb_logs()
DuckDB function truncate_duckdb_logs
try_strptime()
DuckDB function try_strptime
`~~*`()
DuckDB function ~~*
`~~~`()
DuckDB function ~~~
`~~`()
DuckDB function ~~
`~`()
DuckDB function ~
txid_current()
DuckDB function txid_current
typeof()
DuckDB function typeof
ui_is_started()
DuckDB function ui_is_started
union_extract()
DuckDB function union_extract
union_tag()
DuckDB function union_tag
union_value()
DuckDB function union_value
unity_catalog_checkpoint_table()
DuckDB function unity_catalog_checkpoint_table
unity_catalog_force_checkpoint_table()
DuckDB function unity_catalog_force_checkpoint_table
unnest()
DuckDB function unnest
user()
DuckDB function user
user_agent()
DuckDB function user_agent
uuid()
DuckDB function uuid
uuid_extract_timestamp()
DuckDB function uuid_extract_timestamp
uuid_extract_version()
DuckDB function uuid_extract_version
uuidv4()
DuckDB function uuidv4
uuidv7()
DuckDB function uuidv7
var_pop()
DuckDB function var_pop
var_samp()
DuckDB function var_samp
variant_bytes_to_variant()
DuckDB function variant_bytes_to_variant
variant_to_parquet_variant()
DuckDB function variant_to_parquet_variant
vector_type()
DuckDB function vector_type
verify_external()
DuckDB function verify_external
verify_fetch_row()
DuckDB function verify_fetch_row
verify_parallelism()
DuckDB function verify_parallelism
verify_serializer()
DuckDB function verify_serializer
version()
DuckDB function version
vortex_scan()
DuckDB function vortex_scan
vss_join()
DuckDB function vss_join
vss_match()
DuckDB function vss_match
wavg()
DuckDB function wavg
week()
DuckDB function week
weekday()
DuckDB function weekday
weekofyear()
DuckDB function weekofyear
weighted_avg()
DuckDB function weighted_avg
which_secret()
DuckDB function which_secret
whoami()
DuckDB function whoami
write_blob()
DuckDB function write_blob
write_log()
DuckDB function write_log
xor()
DuckDB function xor
year()
DuckDB function year
yearweek()
DuckDB function yearweek