Package: dd 0.0.0.9000

Kirill Müller

dd: Functions Provided by DuckDB

Lists DuckDB functions for integration in R's help system.

Authors:Kirill Müller [aut, cre], cynkra GmbH [fnd, cph]

dd_0.0.0.9000.tar.gz
dd_0.0.0.9000.zip(r-4.7)dd_0.0.0.9000.zip(r-4.6)dd_0.0.0.9000.zip(r-4.5)
dd_0.0.0.9000.tgz(r-4.6-any)dd_0.0.0.9000.tgz(r-4.5-any)
dd_0.0.0.9000.tar.gz(r-4.7-any)dd_0.0.0.9000.tar.gz(r-4.6-any)
dd_0.0.0.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html
DESCRIPTION
card.svg |card.png
dd/json (API)

# Install 'dd' in R:
install.packages('dd', repos = c('https://cynkra.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/cynkra/dd/issues

Pkgdown/docs site:https://cynkra.github.io

On CRAN:

Conda:

4.02 score 13 stars 10 scripts 731 exports 0 dependencies

Last updated from:d0edf3dcca. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK114
source / vignettesOK206
linux-release-x86_64OK135
macos-release-arm64OK91
macos-oldrel-arm64OK87
windows-develOK85
windows-releaseOK85
windows-oldrelOK98
wasm-releaseOK93

Exports:!__postfix!~~!~~*@@>***///&&&%^^@<@<<<=>>>|||~~~~~*~~~absacosacoshaddadd_parquet_keyageaggregateagoaliasall_profiling_outputany_valueapplyapprox_count_distinctapprox_quantileapprox_top_karbitraryarg_maxarg_max_nullarg_max_nulls_lastarg_minarg_min_nullarg_min_nulls_lastargmaxargminarray_aggarray_aggrarray_aggregatearray_appendarray_applyarray_catarray_concatarray_containsarray_cosine_distancearray_cosine_similarityarray_cross_productarray_distancearray_distinctarray_dot_productarray_extractarray_filterarray_grade_uparray_hasarray_has_allarray_has_anyarray_indexofarray_inner_productarray_intersectarray_lengtharray_negative_dot_productarray_negative_inner_productarray_pop_backarray_pop_frontarray_positionarray_prependarray_push_backarray_push_frontarray_reducearray_resizearray_reversearray_reverse_sortarray_selectarray_slicearray_sortarray_to_stringarray_to_string_comma_defaultarray_transformarray_uniquearray_valuearray_wherearray_ziparrow_scanarrow_scan_dumbasciiasinasinhatanatan2atanhavgbarbase64binbit_andbit_countbit_lengthbit_orbit_positionbit_xorbitstringbitstring_aggbool_andbool_orcan_cast_implicitlycardinalitycast_to_typecbrtceilceilingcenturychar_lengthcharacter_lengthcheckpointchrcol_descriptioncollationscombineconcatconcat_wsconstant_or_nullcontainscopy_databasecorrcoscoshcotcountcount_ifcount_starcountifcovar_popcovar_sampcreate_sort_keycume_distcurrent_catalogcurrent_connection_idcurrent_databasecurrent_querycurrent_query_idcurrent_rolecurrent_schemacurrent_schemascurrent_settingcurrent_transaction_idcurrent_usercurrvaldamerau_levenshteindatabase_listdatabase_sizedate_adddate_diffdate_partdate_subdate_truncdatediffdatepartdatesubdatetruncdaydaynamedayofmonthdayofweekdayofyeardays_in_monthdddecadedecodedegreesdense_rankdisable_checkpoint_on_shutdowndisable_loggingdisable_object_cachedisable_optimizerdisable_print_progress_bardisable_profiledisable_profilingdisable_progress_bardisable_verificationdisable_verify_externaldisable_verify_fetch_rowdisable_verify_parallelismdisable_verify_serializerdivideduckdb_approx_database_countduckdb_columnsduckdb_connection_countduckdb_constraintsduckdb_coordinate_systemsduckdb_databasesduckdb_dependenciesduckdb_extensionsduckdb_external_file_cacheduckdb_functionsduckdb_indexesduckdb_keywordsduckdb_log_contextsduckdb_logsduckdb_logs_parsedduckdb_memoryduckdb_optimizersduckdb_prepared_statementsduckdb_profiling_settingsduckdb_schemasduckdb_secret_typesduckdb_secretsduckdb_sequencesduckdb_settingsduckdb_table_sampleduckdb_tablesduckdb_temporary_filesduckdb_typesduckdb_variablesduckdb_viewseditdist3element_atenable_checkpoint_on_shutdownenable_object_cacheenable_optimizerenable_print_progress_barenable_profileenable_profilingenable_progress_barenable_verificationencodeends_withentropyenum_codeenum_firstenum_lastenum_rangeenum_range_boundaryepochepoch_msepoch_nsepoch_usequi_width_binseraerrorevenexpextension_versionsfactorialfavgfdivfillfilterfinalizefirstfirst_valueflattenfloorfmodforce_checkpointformat_bytesformat_pg_typeformat_typeformatReadableDecimalSizeformatReadableSizefrom_base64from_binaryfrom_hexfsumfunctionsgammagcdgen_random_uuidgenerate_seriesgenerate_subscriptsgeomeangeometric_meanget_bitget_block_sizeget_current_timestampget_typegetvariableglobgrade_upgreatestgreatest_common_divisorgroup_concathamminghas_any_column_privilegehas_column_privilegehas_database_privilegehas_foreign_data_wrapper_privilegehas_function_privilegehas_language_privilegehas_schema_privilegehas_sequence_privilegehas_server_privilegehas_table_privilegehas_tablespace_privilegehashhexhistogramhistogram_exacthistogram_valueshourilike_escapeimport_databasein_search_pathinet_client_addrinet_client_portinet_server_addrinet_server_portinstris_histogram_other_binisfiniteisinfisnanisodowisoyearjaccardjaro_similarityjaro_winkler_similarityjuliankahan_sumkurtosiskurtosis_poplaglastlast_daylast_valuelcaselcmleadleastleast_common_multipleleftleft_graphemelenlength_graphemelevenshteinlgammalike_escapelistlist_aggrlist_aggregatelist_any_valuelist_appendlist_applylist_approx_count_distinctlist_avglist_bit_andlist_bit_orlist_bit_xorlist_bool_andlist_bool_orlist_catlist_concatlist_containslist_cosine_distancelist_cosine_similaritylist_countlist_distancelist_distinctlist_dot_productlist_elementlist_entropylist_extractlist_filterlist_firstlist_grade_uplist_haslist_has_alllist_has_anylist_histogramlist_indexoflist_inner_productlist_intersectlist_kurtosislist_kurtosis_poplist_lastlist_madlist_maxlist_medianlist_minlist_modelist_negative_dot_productlist_negative_inner_productlist_packlist_positionlist_prependlist_productlist_reducelist_resizelist_reverselist_reverse_sortlist_selectlist_semlist_skewnesslist_slicelist_sortlist_stddev_poplist_stddev_samplist_string_agglist_sumlist_transformlist_uniquelist_valuelist_var_poplist_var_samplist_wherelist_ziplistagglnloglog10log2lowerlpadltrimmadmake_datemake_timemake_timestampmake_timestamp_msmake_timestamp_nsmake_typemapmap_concatmap_containsmap_contains_entrymap_contains_valuemap_entriesmap_extractmap_extract_valuemap_from_entriesmap_keysmap_to_pg_oidmap_valuesmaxmax_bymd5md5_numbermd5_number_lowermd5_number_uppermeanmedianmetadata_infomicrosecondmillenniummillisecondminmin_byminutemismatchesmodmodemonthmonthnamemultiplynanosecondnextafternextvalnfc_normalizenormalized_intervalnot_ilike_escapenot_like_escapenownth_valuentilenullifobj_descriptionoctet_lengthordparquet_bloom_probeparquet_file_metadataparquet_full_metadataparquet_kv_metadataparquet_metadataparquet_scanparquet_schemaparse_dirnameparse_dirpathparse_duckdb_log_messageparse_filenameparse_formatted_bytesparse_pathpercent_rankpg_collation_is_visiblepg_conf_load_timepg_conversion_is_visiblepg_function_is_visiblepg_get_constraintdefpg_get_exprpg_get_viewdefpg_has_rolepg_is_other_temp_schemapg_my_temp_schemapg_opclass_is_visiblepg_operator_is_visiblepg_opfamily_is_visiblepg_postmaster_start_timepg_size_prettypg_sleeppg_table_is_visiblepg_ts_config_is_visiblepg_ts_dict_is_visiblepg_ts_parser_is_visiblepg_ts_template_is_visiblepg_type_is_visiblepg_typeofpiplatformpositionpowpowerpragma_collationspragma_database_sizepragma_metadata_infopragma_platformpragma_showpragma_storage_infopragma_table_infopragma_user_agentpragma_versionprefixprintfproductquantilequantile_contquantile_discquarterqueryquery_tabler_dataframe_scanradiansrandomrangerankrank_denseread_blobread_csvread_csv_autoread_duckdbread_parquetread_textreduceregexp_escaperegexp_extractregexp_extract_allregexp_full_matchregexp_matchesregexp_replaceregexp_split_to_arrayregexp_split_to_tableregr_avgxregr_avgyregr_countregr_interceptregr_r2regr_sloperegr_sxxregr_sxyregr_syyrepeatrepeat_rowreplacereplace_typereservoir_quantilereverserightright_graphemeroundround_evenroundbankersrowrow_numberrpadrtrimsecondsemseq_scansession_userset_bitsetseedsha1sha256shobj_descriptionshowshow_databasesshow_tablesshow_tables_expandedsignsignbitsinsinhskewnesssleep_mssplitsplit_partsqrtst_asbinaryst_astextst_aswkbst_aswktst_crsst_geomfromwkbst_intersects_extentst_setcrsstarts_withstatsstddevstddev_popstddev_sampstorage_infostr_splitstr_split_regexstrftimestring_aggstring_splitstring_split_regexstring_to_arraystrip_accentsstrlenstrposstrptimestruct_concatstruct_containsstruct_extractstruct_hasstruct_indexofstruct_insertstruct_keysstruct_packstruct_positionstruct_updatestruct_valuessubstrsubstringsubstring_graphemesubtractsuffixsumsum_no_overflowsumkahansummaryswitchtable_infotantanhtest_all_typestest_vector_typestime_buckettimetz_byte_comparabletimezonetimezone_hourtimezone_minuteto_baseto_base64to_binaryto_centuriesto_daysto_decadesto_hexto_hoursto_microsecondsto_millenniato_millisecondsto_minutesto_monthsto_quartersto_secondsto_timestampto_weeksto_yearstransaction_timestamptranslatetrimtrunctruncate_duckdb_logstry_strptimetxid_currenttypeofucaseunbinunhexunicodeunion_extractunion_tagunion_valueunnestunpivot_listupperurl_decodeurl_encodeuseruser_agentuuiduuid_extract_timestampuuid_extract_versionuuidv4uuidv7var_popvar_sampvariancevariant_bytes_to_variantvariant_extractvariant_normalizevariant_to_parquet_variantvariant_typeofvector_typeverify_externalverify_fetch_rowverify_parallelismverify_serializerversionwavgweekweekdayweekofyearweighted_avgwhich_secretwrite_logxoryearyearweek

Dependencies:

Readme and manuals

Help Manual

Help pageTopics
DuckDB function //
DuckDB function &&
DuckDB function <<<<
DuckDB function >>>>
DuckDB function ~~
DuckDB function ~~~~
DuckDB function ~~*~~*
DuckDB function ~~~~~~
DuckDB function abs@ abs
DuckDB function acosacos
DuckDB function acoshacosh
DuckDB function addadd
DuckDB function add_parquet_keyadd_parquet_key
DuckDB function ageage
DuckDB function agoago
DuckDB function aliasalias
DuckDB function all_profiling_outputall_profiling_output
DuckDB function any_valueany_value
DuckDB function approx_count_distinctapprox_count_distinct
DuckDB function approx_quantileapprox_quantile
DuckDB function approx_top_kapprox_top_k
DuckDB function arg_maxargmax arg_max max_by
DuckDB function arg_max_nullarg_max_null
DuckDB function arg_max_nulls_lastarg_max_nulls_last
DuckDB function arg_minargmin arg_min min_by
DuckDB function arg_min_nullarg_min_null
DuckDB function arg_min_nulls_lastarg_min_nulls_last
DuckDB function array_appendarray_append
DuckDB function array_cosine_distancearray_cosine_distance
DuckDB function array_cosine_similarityarray_cosine_similarity
DuckDB function array_cross_productarray_cross_product
DuckDB function array_distancearray_distance
DuckDB function array_extractarray_extract
DuckDB function array_inner_productarray_dot_product array_inner_product
DuckDB function array_lengtharray_length
DuckDB function array_negative_inner_productarray_negative_dot_product array_negative_inner_product
DuckDB function array_pop_backarray_pop_back
DuckDB function array_pop_frontarray_pop_front
DuckDB function array_prependarray_prepend
DuckDB function array_push_backarray_push_back
DuckDB function array_push_frontarray_push_front
DuckDB function array_reversearray_reverse
DuckDB function array_to_stringarray_to_string
DuckDB function array_to_string_comma_defaultarray_to_string_comma_default
DuckDB function array_valuearray_value
DuckDB function arrow_scanarrow_scan
DuckDB function arrow_scan_dumbarrow_scan_dumb
DuckDB function asciiascii
DuckDB function asinasin
DuckDB function asinhasinh
DuckDB function atanatan
DuckDB function atan2atan2
DuckDB function atanhatanh
DuckDB function avgavg mean
DuckDB function barbar
DuckDB function binbin to_binary
DuckDB function bit_andbit_and
DuckDB function bit_countbit_count
DuckDB function bit_lengthbit_length
DuckDB function bit_orbit_or
DuckDB function bit_positionbit_position
DuckDB function bit_xorbit_xor
DuckDB function bitstringbitstring
DuckDB function bitstring_aggbitstring_agg
DuckDB function bool_andbool_and
DuckDB function bool_orbool_or
DuckDB function can_cast_implicitlycan_cast_implicitly
DuckDB function cardinalitycardinality
DuckDB function cast_to_typecast_to_type
DuckDB function cbrtcbrt
DuckDB function ceilceil ceiling
DuckDB function centurycentury
DuckDB function checkpointcheckpoint
DuckDB function chrchr
DuckDB function col_descriptioncol_description
DuckDB function collationscollations
DuckDB function combinecombine
DuckDB function concatconcat
DuckDB function concat_wsconcat_ws
DuckDB function constant_or_nullconstant_or_null
DuckDB function containscontains
DuckDB function copy_databasecopy_database
DuckDB function corrcorr
DuckDB function coscos
DuckDB function coshcosh
DuckDB function cotcot
DuckDB function countcount
DuckDB function count_ifcountif count_if
DuckDB function count_starcount_star
DuckDB function covar_popcovar_pop
DuckDB function covar_sampcovar_samp
DuckDB function create_sort_keycreate_sort_key
DuckDB function cume_distcume_dist
DuckDB function current_catalogcurrent_catalog
DuckDB function current_connection_idcurrent_connection_id
DuckDB function current_databasecurrent_database
DuckDB function current_querycurrent_query
DuckDB function current_query_idcurrent_query_id
DuckDB function current_rolecurrent_role
DuckDB function current_schemacurrent_schema
DuckDB function current_schemascurrent_schemas
DuckDB function current_settingcurrent_setting
DuckDB function current_transaction_idcurrent_transaction_id
DuckDB function current_usercurrent_user
DuckDB function currvalcurrval
DuckDB function damerau_levenshteindamerau_levenshtein
DuckDB function database_listdatabase_list
DuckDB function database_sizedatabase_size
DuckDB function date_adddate_add
DuckDB function date_diffdatediff date_diff
DuckDB function date_partdatepart date_part
DuckDB function date_subdatesub date_sub
DuckDB function date_truncdatetrunc date_trunc
DuckDB function dayday
DuckDB function daynamedayname
DuckDB function dayofmonthdayofmonth
DuckDB function dayofweekdayofweek
DuckDB function dayofyeardayofyear
DuckDB function days_in_monthdays_in_month
DuckDB functionsdd
DuckDB function decadedecade
DuckDB function decodedecode
DuckDB function degreesdegrees
DuckDB function dense_rankdense_rank
DuckDB function disable_checkpoint_on_shutdowndisable_checkpoint_on_shutdown
DuckDB function disable_loggingdisable_logging
DuckDB function disable_object_cachedisable_object_cache
DuckDB function disable_optimizerdisable_optimizer
DuckDB function disable_print_progress_bardisable_print_progress_bar
DuckDB function disable_profiledisable_profile
DuckDB function disable_profilingdisable_profiling
DuckDB function disable_progress_bardisable_progress_bar
DuckDB function disable_verificationdisable_verification
DuckDB function disable_verify_externaldisable_verify_external
DuckDB function disable_verify_fetch_rowdisable_verify_fetch_row
DuckDB function disable_verify_parallelismdisable_verify_parallelism
DuckDB function disable_verify_serializerdisable_verify_serializer
DuckDB function divide// divide
DuckDB function duckdb_approx_database_countduckdb_approx_database_count
DuckDB function duckdb_columnsduckdb_columns
DuckDB function duckdb_connection_countduckdb_connection_count
DuckDB function duckdb_constraintsduckdb_constraints
DuckDB function duckdb_coordinate_systemsduckdb_coordinate_systems
DuckDB function duckdb_databasesduckdb_databases
DuckDB function duckdb_dependenciesduckdb_dependencies
DuckDB function duckdb_extensionsduckdb_extensions
DuckDB function duckdb_external_file_cacheduckdb_external_file_cache
DuckDB function duckdb_functionsduckdb_functions
DuckDB function duckdb_indexesduckdb_indexes
DuckDB function duckdb_keywordsduckdb_keywords
DuckDB function duckdb_log_contextsduckdb_log_contexts
DuckDB function duckdb_logsduckdb_logs
DuckDB function duckdb_logs_parsedduckdb_logs_parsed
DuckDB function duckdb_memoryduckdb_memory
DuckDB function duckdb_optimizersduckdb_optimizers
DuckDB function duckdb_prepared_statementsduckdb_prepared_statements
DuckDB function duckdb_profiling_settingsduckdb_profiling_settings
DuckDB function duckdb_schemasduckdb_schemas
DuckDB function duckdb_secret_typesduckdb_secret_types
DuckDB function duckdb_secretsduckdb_secrets
DuckDB function duckdb_sequencesduckdb_sequences
DuckDB function duckdb_settingsduckdb_settings
DuckDB function duckdb_table_sampleduckdb_table_sample
DuckDB function duckdb_tablesduckdb_tables
DuckDB function duckdb_temporary_filesduckdb_temporary_files
DuckDB function duckdb_typesduckdb_types
DuckDB function duckdb_variablesduckdb_variables
DuckDB function duckdb_viewsduckdb_views
DuckDB function enable_checkpoint_on_shutdownenable_checkpoint_on_shutdown
DuckDB function enable_object_cacheenable_object_cache
DuckDB function enable_optimizerenable_optimizer
DuckDB function enable_print_progress_barenable_print_progress_bar
DuckDB function enable_profileenable_profile
DuckDB function enable_profilingenable_profiling
DuckDB function enable_progress_barenable_progress_bar
DuckDB function enable_verificationenable_verification
DuckDB function encodeencode
DuckDB function entropyentropy
DuckDB function enum_codeenum_code
DuckDB function enum_firstenum_first
DuckDB function enum_lastenum_last
DuckDB function enum_rangeenum_range
DuckDB function enum_range_boundaryenum_range_boundary
DuckDB function epochepoch
DuckDB function epoch_msepoch_ms
DuckDB function epoch_nsepoch_ns
DuckDB function epoch_usepoch_us
DuckDB function equi_width_binsequi_width_bins
DuckDB function eraera
DuckDB function errorerror
DuckDB function eveneven
DuckDB function expexp
DuckDB function extension_versionsextension_versions
DuckDB function factorial!__postfix factorial
DuckDB function favgfavg
DuckDB function fdivfdiv
DuckDB function fillfill
DuckDB function finalizefinalize
DuckDB function firstarbitrary first
DuckDB function first_valuefirst_value
DuckDB function flattenflatten
DuckDB function floorfloor
DuckDB function fmodfmod
DuckDB function force_checkpointforce_checkpoint
DuckDB function format_bytesformatReadableSize format_bytes
DuckDB function format_pg_typeformat_pg_type
DuckDB function format_typeformat_type
DuckDB function formatReadableDecimalSizeformatReadableDecimalSize
DuckDB function from_base64from_base64
DuckDB function functionsfunctions
DuckDB function gammagamma
DuckDB function generate_seriesgenerate_series
DuckDB function generate_subscriptsgenerate_subscripts
DuckDB function geomeangeomean
DuckDB function geometric_meangeometric_mean
DuckDB function get_bitget_bit
DuckDB function get_block_sizeget_block_size
DuckDB function get_current_timestampget_current_timestamp now transaction_timestamp
DuckDB function get_typeget_type
DuckDB function getvariablegetvariable
DuckDB function globglob
DuckDB function greatestgreatest
DuckDB function greatest_common_divisorgcd greatest_common_divisor
DuckDB function hamminghamming mismatches
DuckDB function has_any_column_privilegehas_any_column_privilege
DuckDB function has_column_privilegehas_column_privilege
DuckDB function has_database_privilegehas_database_privilege
DuckDB function has_foreign_data_wrapper_privilegehas_foreign_data_wrapper_privilege
DuckDB function has_function_privilegehas_function_privilege
DuckDB function has_language_privilegehas_language_privilege
DuckDB function has_schema_privilegehas_schema_privilege
DuckDB function has_sequence_privilegehas_sequence_privilege
DuckDB function has_server_privilegehas_server_privilege
DuckDB function has_table_privilegehas_table_privilege
DuckDB function has_tablespace_privilegehas_tablespace_privilege
DuckDB function hashhash
DuckDB function hexhex to_hex
DuckDB function histogramhistogram
DuckDB function histogram_exacthistogram_exact
DuckDB function histogram_valueshistogram_values
DuckDB function hourhour
DuckDB function ilike_escapeilike_escape
DuckDB function import_databaseimport_database
DuckDB function in_search_pathin_search_path
DuckDB function inet_client_addrinet_client_addr
DuckDB function inet_client_portinet_client_port
DuckDB function inet_server_addrinet_server_addr
DuckDB function inet_server_portinet_server_port
DuckDB function instrinstr position strpos
DuckDB function is_histogram_other_binis_histogram_other_bin
DuckDB function isfiniteisfinite
DuckDB function isinfisinf
DuckDB function isnanisnan
DuckDB function isodowisodow
DuckDB function isoyearisoyear
DuckDB function jaccardjaccard
DuckDB function jaro_similarityjaro_similarity
DuckDB function jaro_winkler_similarityjaro_winkler_similarity
DuckDB function julianjulian
DuckDB function kahan_sumfsum kahan_sum sumkahan
DuckDB function kurtosiskurtosis
DuckDB function kurtosis_popkurtosis_pop
DuckDB function laglag
DuckDB function lastlast
DuckDB function last_daylast_day
DuckDB function last_valuelast_value
DuckDB function leadlead
DuckDB function leastleast
DuckDB function least_common_multiplelcm least_common_multiple
DuckDB function leftleft
DuckDB function left_graphemeleft_grapheme
DuckDB function lencharacter_length char_length len
DuckDB function length_graphemelength_grapheme
DuckDB function levenshteineditdist3 levenshtein
DuckDB function lgammalgamma
DuckDB function like_escapelike_escape
DuckDB function listarray_agg list
DuckDB function list_aggregateaggregate array_aggr array_aggregate list_aggr list_aggregate
DuckDB function list_any_valuelist_any_value
DuckDB function list_appendlist_append
DuckDB function list_approx_count_distinctlist_approx_count_distinct
DuckDB function list_avglist_avg
DuckDB function list_bit_andlist_bit_and
DuckDB function list_bit_orlist_bit_or
DuckDB function list_bit_xorlist_bit_xor
DuckDB function list_bool_andlist_bool_and
DuckDB function list_bool_orlist_bool_or
DuckDB function list_concatarray_cat array_concat list_cat list_concat
DuckDB function list_containsarray_contains array_has list_contains list_has
DuckDB function list_cosine_distance<=> list_cosine_distance
DuckDB function list_cosine_similaritylist_cosine_similarity
DuckDB function list_countlist_count
DuckDB function list_distancelist_distance
DuckDB function list_distinctarray_distinct list_distinct
DuckDB function list_entropylist_entropy
DuckDB function list_extractlist_element list_extract
DuckDB function list_filterarray_filter filter list_filter
DuckDB function list_firstlist_first
DuckDB function list_grade_uparray_grade_up grade_up list_grade_up
DuckDB function list_has_all<@ @> array_has_all list_has_all
DuckDB function list_has_any&& array_has_any list_has_any st_intersects_extent
DuckDB function list_histogramlist_histogram
DuckDB function list_inner_productlist_dot_product list_inner_product
DuckDB function list_intersectarray_intersect list_intersect
DuckDB function list_kurtosislist_kurtosis
DuckDB function list_kurtosis_poplist_kurtosis_pop
DuckDB function list_lastlist_last
DuckDB function list_madlist_mad
DuckDB function list_maxlist_max
DuckDB function list_medianlist_median
DuckDB function list_minlist_min
DuckDB function list_modelist_mode
DuckDB function list_negative_inner_productlist_negative_dot_product list_negative_inner_product
DuckDB function list_positionarray_indexof array_position list_indexof list_position
DuckDB function list_prependlist_prepend
DuckDB function list_productlist_product
DuckDB function list_reducearray_reduce list_reduce reduce
DuckDB function list_resizearray_resize list_resize
DuckDB function list_reverselist_reverse
DuckDB function list_reverse_sortarray_reverse_sort list_reverse_sort
DuckDB function list_selectarray_select list_select
DuckDB function list_semlist_sem
DuckDB function list_skewnesslist_skewness
DuckDB function list_slicearray_slice list_slice
DuckDB function list_sortarray_sort list_sort
DuckDB function list_stddev_poplist_stddev_pop
DuckDB function list_stddev_samplist_stddev_samp
DuckDB function list_string_agglist_string_agg
DuckDB function list_sumlist_sum
DuckDB function list_transformapply array_apply array_transform list_apply list_transform
DuckDB function list_uniquearray_unique list_unique
DuckDB function list_valuelist_pack list_value
DuckDB function list_var_poplist_var_pop
DuckDB function list_var_samplist_var_samp
DuckDB function list_wherearray_where list_where
DuckDB function list_ziparray_zip list_zip
DuckDB function lnln
DuckDB function loglog
DuckDB function log10log10
DuckDB function log2log2
DuckDB function lowerlcase lower
DuckDB function lpadlpad
DuckDB function ltrimltrim
DuckDB function madmad
DuckDB function make_datemake_date
DuckDB function make_timemake_time
DuckDB function make_timestampmake_timestamp
DuckDB function make_timestamp_msmake_timestamp_ms
DuckDB function make_timestamp_nsmake_timestamp_ns
DuckDB function make_typemake_type
DuckDB function mapmap
DuckDB function map_concatmap_concat
DuckDB function map_containsmap_contains
DuckDB function map_contains_entrymap_contains_entry
DuckDB function map_contains_valuemap_contains_value
DuckDB function map_entriesmap_entries
DuckDB function map_extractelement_at map_extract
DuckDB function map_extract_valuemap_extract_value
DuckDB function map_from_entriesmap_from_entries
DuckDB function map_keysmap_keys
DuckDB function map_to_pg_oidmap_to_pg_oid
DuckDB function map_valuesmap_values
DuckDB function maxmax
DuckDB function md5md5
DuckDB function md5_numbermd5_number
DuckDB function md5_number_lowermd5_number_lower
DuckDB function md5_number_uppermd5_number_upper
DuckDB function medianmedian
DuckDB function metadata_infometadata_info
DuckDB function microsecondmicrosecond
DuckDB function millenniummillennium
DuckDB function millisecondmillisecond
DuckDB function minmin
DuckDB function minuteminute
DuckDB function mod% mod
DuckDB function modemode
DuckDB function monthmonth
DuckDB function monthnamemonthname
DuckDB function multiply* multiply
DuckDB function nanosecondnanosecond
DuckDB function nextafternextafter
DuckDB function nextvalnextval
DuckDB function nfc_normalizenfc_normalize
DuckDB function normalized_intervalnormalized_interval
DuckDB function not_ilike_escapenot_ilike_escape
DuckDB function not_like_escapenot_like_escape
DuckDB function !~~!~~ not-~~
DuckDB function !~~*!~~* not-~~*
DuckDB function nth_valuenth_value
DuckDB function ntilentile
DuckDB function nullifnullif
DuckDB function obj_descriptionobj_description
DuckDB function octet_lengthoctet_length
DuckDB function |or- |
DuckDB function ||or--or ||
DuckDB function parquet_bloom_probeparquet_bloom_probe
DuckDB function parquet_file_metadataparquet_file_metadata
DuckDB function parquet_full_metadataparquet_full_metadata
DuckDB function parquet_kv_metadataparquet_kv_metadata
DuckDB function parquet_metadataparquet_metadata
DuckDB function parquet_scanparquet_scan
DuckDB function parquet_schemaparquet_schema
DuckDB function parse_dirnameparse_dirname
DuckDB function parse_dirpathparse_dirpath
DuckDB function parse_duckdb_log_messageparse_duckdb_log_message
DuckDB function parse_filenameparse_filename
DuckDB function parse_formatted_bytesparse_formatted_bytes
DuckDB function parse_pathparse_path
DuckDB function percent_rankpercent_rank
DuckDB function pg_collation_is_visiblepg_collation_is_visible
DuckDB function pg_conf_load_timepg_conf_load_time
DuckDB function pg_conversion_is_visiblepg_conversion_is_visible
DuckDB function pg_function_is_visiblepg_function_is_visible
DuckDB function pg_get_constraintdefpg_get_constraintdef
DuckDB function pg_get_exprpg_get_expr
DuckDB function pg_get_viewdefpg_get_viewdef
DuckDB function pg_has_rolepg_has_role
DuckDB function pg_is_other_temp_schemapg_is_other_temp_schema
DuckDB function pg_my_temp_schemapg_my_temp_schema
DuckDB function pg_opclass_is_visiblepg_opclass_is_visible
DuckDB function pg_operator_is_visiblepg_operator_is_visible
DuckDB function pg_opfamily_is_visiblepg_opfamily_is_visible
DuckDB function pg_postmaster_start_timepg_postmaster_start_time
DuckDB function pg_size_prettypg_size_pretty
DuckDB function pg_sleeppg_sleep
DuckDB function pg_table_is_visiblepg_table_is_visible
DuckDB function pg_ts_config_is_visiblepg_ts_config_is_visible
DuckDB function pg_ts_dict_is_visiblepg_ts_dict_is_visible
DuckDB function pg_ts_parser_is_visiblepg_ts_parser_is_visible
DuckDB function pg_ts_template_is_visiblepg_ts_template_is_visible
DuckDB function pg_type_is_visiblepg_type_is_visible
DuckDB function pg_typeofpg_typeof
DuckDB function pipi
DuckDB function platformplatform
DuckDB function pow** pow power ^
DuckDB function pragma_collationspragma_collations
DuckDB function pragma_database_sizepragma_database_size
DuckDB function pragma_metadata_infopragma_metadata_info
DuckDB function pragma_platformpragma_platform
DuckDB function pragma_showpragma_show
DuckDB function pragma_storage_infopragma_storage_info
DuckDB function pragma_table_infopragma_table_info
DuckDB function pragma_user_agentpragma_user_agent
DuckDB function pragma_versionpragma_version
DuckDB function prefixprefix
DuckDB function printfprintf
DuckDB function productproduct
DuckDB function quantile_contquantile_cont
DuckDB function quantile_discquantile quantile_disc
DuckDB function quarterquarter
DuckDB function queryquery
DuckDB function query_tablequery_table
DuckDB function r_dataframe_scanr_dataframe_scan
DuckDB function radiansradians
DuckDB function randomrandom
DuckDB function rangerange
DuckDB function rankrank
DuckDB function rank_denserank_dense
DuckDB function read_blobread_blob
DuckDB function read_csvread_csv
DuckDB function read_csv_autoread_csv_auto
DuckDB function read_duckdbread_duckdb
DuckDB function read_parquetread_parquet
DuckDB function read_textread_text
DuckDB function regexp_escaperegexp_escape
DuckDB function regexp_extractregexp_extract
DuckDB function regexp_extract_allregexp_extract_all
DuckDB function regexp_full_matchregexp_full_match
DuckDB function regexp_matchesregexp_matches
DuckDB function regexp_replaceregexp_replace
DuckDB function regexp_split_to_tableregexp_split_to_table
DuckDB function regr_avgxregr_avgx
DuckDB function regr_avgyregr_avgy
DuckDB function regr_countregr_count
DuckDB function regr_interceptregr_intercept
DuckDB function regr_r2regr_r2
DuckDB function regr_sloperegr_slope
DuckDB function regr_sxxregr_sxx
DuckDB function regr_sxyregr_sxy
DuckDB function regr_syyregr_syy
DuckDB function repeatrepeat
DuckDB function repeat_rowrepeat_row
DuckDB function replacereplace
DuckDB function replace_typereplace_type
DuckDB function reservoir_quantilereservoir_quantile
DuckDB function reversereverse
DuckDB function rightright
DuckDB function right_graphemeright_grapheme
DuckDB function roundround
DuckDB function round_evenround_even
DuckDB function roundbankersroundbankers
DuckDB function rowrow
DuckDB function row_numberrow_number
DuckDB function rpadrpad
DuckDB function rtrimrtrim
DuckDB function secondsecond
DuckDB function semsem
DuckDB function seq_scanseq_scan
DuckDB function session_usersession_user
DuckDB function set_bitset_bit
DuckDB function setseedsetseed
DuckDB function sha1sha1
DuckDB function sha256sha256
DuckDB function shobj_descriptionshobj_description
DuckDB function showshow
DuckDB function show_databasesshow_databases
DuckDB function show_tablesshow_tables
DuckDB function show_tables_expandedshow_tables_expanded
DuckDB function signsign
DuckDB function signbitsignbit
DuckDB function sinsin
DuckDB function sinhsinh
DuckDB function skewnessskewness
DuckDB function sleep_mssleep_ms
DuckDB function split_partsplit_part
DuckDB function sqrtsqrt
DuckDB function st_astextst_astext st_aswkt
DuckDB function st_aswkbst_asbinary st_aswkb
DuckDB function st_crsst_crs
DuckDB function st_geomfromwkbst_geomfromwkb
DuckDB function st_setcrsst_setcrs
DuckDB function starts_withstarts_with ^@
DuckDB function statsstats
DuckDB function stddev_popstddev_pop
DuckDB function stddev_sampstddev stddev_samp
DuckDB function storage_infostorage_info
DuckDB function strftimestrftime
DuckDB function string_agggroup_concat listagg string_agg
DuckDB function string_splitsplit string_split string_to_array str_split
DuckDB function string_split_regexregexp_split_to_array string_split_regex str_split_regex
DuckDB function strip_accentsstrip_accents
DuckDB function strlenstrlen
DuckDB function strptimestrptime
DuckDB function struct_concatstruct_concat
DuckDB function struct_containsstruct_contains struct_has
DuckDB function struct_extractstruct_extract
DuckDB function struct_insertstruct_insert
DuckDB function struct_keysstruct_keys
DuckDB function struct_packstruct_pack
DuckDB function struct_positionstruct_indexof struct_position
DuckDB function struct_updatestruct_update
DuckDB function struct_valuesstruct_values
DuckDB function substringsubstr substring
DuckDB function substring_graphemesubstring_grapheme
DuckDB function subtractsubtract
DuckDB function suffixends_with suffix
DuckDB function sumsum
DuckDB function sum_no_overflowsum_no_overflow
DuckDB function summarysummary
DuckDB function switchswitch
DuckDB function table_infotable_info
DuckDB function tantan
DuckDB function tanhtanh
DuckDB function test_all_typestest_all_types
DuckDB function test_vector_typestest_vector_types
DuckDB function time_buckettime_bucket
DuckDB function timetz_byte_comparabletimetz_byte_comparable
DuckDB function timezonetimezone
DuckDB function timezone_hourtimezone_hour
DuckDB function timezone_minutetimezone_minute
DuckDB function to_baseto_base
DuckDB function to_base64base64 to_base64
DuckDB function to_centuriesto_centuries
DuckDB function to_daysto_days
DuckDB function to_decadesto_decades
DuckDB function to_hoursto_hours
DuckDB function to_microsecondsto_microseconds
DuckDB function to_millenniato_millennia
DuckDB function to_millisecondsto_milliseconds
DuckDB function to_minutesto_minutes
DuckDB function to_monthsto_months
DuckDB function to_quartersto_quarters
DuckDB function to_secondsto_seconds
DuckDB function to_timestampto_timestamp
DuckDB function to_weeksto_weeks
DuckDB function to_yearsto_years
DuckDB function translatetranslate
DuckDB function trimtrim
DuckDB function trunctrunc
DuckDB function truncate_duckdb_logstruncate_duckdb_logs
DuckDB function try_strptimetry_strptime
DuckDB function txid_currenttxid_current
DuckDB function typeoftypeof
DuckDB function unbinfrom_binary unbin
DuckDB function unhexfrom_hex unhex
DuckDB function unicodeord unicode
DuckDB function union_extractunion_extract
DuckDB function union_tagunion_tag
DuckDB function union_valueunion_value
DuckDB function unnestunnest
DuckDB function unpivot_listunpivot_list
DuckDB function upperucase upper
DuckDB function url_decodeurl_decode
DuckDB function url_encodeurl_encode
DuckDB function useruser
DuckDB function user_agentuser_agent
DuckDB function uuidgen_random_uuid uuid
DuckDB function uuid_extract_timestampuuid_extract_timestamp
DuckDB function uuid_extract_versionuuid_extract_version
DuckDB function uuidv4uuidv4
DuckDB function uuidv7uuidv7
DuckDB function var_popvar_pop
DuckDB function var_sampvariance var_samp
DuckDB function variant_bytes_to_variantvariant_bytes_to_variant
DuckDB function variant_extractvariant_extract
DuckDB function variant_normalizevariant_normalize
DuckDB function variant_to_parquet_variantvariant_to_parquet_variant
DuckDB function variant_typeofvariant_typeof
DuckDB function vector_typevector_type
DuckDB function verify_externalverify_external
DuckDB function verify_fetch_rowverify_fetch_row
DuckDB function verify_parallelismverify_parallelism
DuckDB function verify_serializerverify_serializer
DuckDB function versionversion
DuckDB function wavgwavg
DuckDB function weekweek
DuckDB function weekdayweekday
DuckDB function weekofyearweekofyear
DuckDB function weighted_avgweighted_avg
DuckDB function which_secretwhich_secret
DuckDB function write_logwrite_log
DuckDB function xorxor
DuckDB function yearyear
DuckDB function yearweekyearweek