List Database Functions (DuckDB/MotherDuck)

Returns a lazy table listing available SQL functions from the current DuckDB/MotherDuck connection using `duckdb_functions()`.

Usage

list_fns(.con)

Arguments

.con

A valid `DBI` connection (DuckDB or MotherDuck).

Value

A `dbplyr` lazy tibble (`tbl_dbi`) with function metadata (e.g., `function_name`, `schema`, `is_aggregate`, `is_alias`, etc.).

Details

This wrapper validates the connection and then queries `duckdb_functions()` to enumerate function metadata. The result is a `dbplyr` lazy tibble (`tbl_dbi`); call `collect()` to materialize it in R.

See also

[DBI::dbConnect()], [dbplyr::tbl()]