duckplus.functions

Domain-organised DuckDB function helpers.

Submodules

• duckplus.functions._base
• duckplus.functions.aggregate
• duckplus.functions.scalar

Attributes

SIDE_EFFECT_MODULES

Functions

approx_count_distinct(...)	Call DuckDB function approx_count_distinct.
approx_count_distinct_filter(...)	Call DuckDB function approx_count_distinct with FILTER.
approx_quantile_generic(...)	Call DuckDB function approx_quantile.
approx_quantile_generic_filter(...)	Call DuckDB function approx_quantile with FILTER.
approx_quantile_numeric(...)	Call DuckDB function approx_quantile.
approx_quantile_numeric_filter(...)	Call DuckDB function approx_quantile with FILTER.
approx_top_k(...)	Call DuckDB function approx_top_k.
approx_top_k_filter(...)	Call DuckDB function approx_top_k with FILTER.
histogram(...)	Call DuckDB function histogram.
histogram_exact(...)	Call DuckDB function histogram_exact.
histogram_exact_filter(...)	Call DuckDB function histogram_exact with FILTER.
histogram_filter(...)	Call DuckDB function histogram with FILTER.
arg_max(→ duckplus.static_typed.expression.TypedExpression)
arg_max_filter(...)
arg_max_null(...)
arg_max_null_filter(...)
arg_min(→ duckplus.static_typed.expression.TypedExpression)
arg_min_filter(...)
arg_min_null(...)
arg_min_null_filter(...)
max_by(→ duckplus.static_typed.expression.TypedExpression)
max_by_filter(...)
min_by(→ duckplus.static_typed.expression.TypedExpression)
min_by_filter(...)
max(→ duckplus.static_typed.expression.TypedExpression)	Call DuckDB function max.
max_filter(...)	Call DuckDB function max with FILTER.
min(→ duckplus.static_typed.expression.TypedExpression)	Call DuckDB function min.
min_filter(...)	Call DuckDB function min with FILTER.
bool_and(...)	Call DuckDB function bool_and.
bool_and_filter(...)	Call DuckDB function bool_and with FILTER.
bool_or(...)	Call DuckDB function bool_or.
bool_or_filter(...)	Call DuckDB function bool_or with FILTER.
bit_and(...)	Call DuckDB function bit_and.
bit_and_filter(...)	Call DuckDB function bit_and with FILTER.
bit_or(...)	Call DuckDB function bit_or.
bit_or_filter(...)	Call DuckDB function bit_or with FILTER.
bit_xor(...)	Call DuckDB function bit_xor.
bit_xor_filter(...)	Call DuckDB function bit_xor with FILTER.
bitstring_agg(...)	Call DuckDB function bitstring_agg.
bitstring_agg_filter(...)	Call DuckDB function bitstring_agg with FILTER.
count(→ duckplus.static_typed.expression.NumericExpression)	Call DuckDB function count.
count_filter(...)	Call DuckDB function count with FILTER.
count_if(...)	Call DuckDB function count_if.
count_if_filter(...)	Call DuckDB function count_if with FILTER.
count_star(...)	Call DuckDB function count_star.
count_star_filter(...)	Call DuckDB function count_star with FILTER.
countif(...)	Call DuckDB function countif.
countif_filter(...)	Call DuckDB function countif with FILTER.
any_value(...)	Call DuckDB function any_value.
any_value_filter(...)	Call DuckDB function any_value with FILTER.
list_filter(...)	Call DuckDB function list with FILTER.
median_filter(...)	Call DuckDB function median with FILTER.
mode_filter(...)	Call DuckDB function mode with FILTER.
quantile(...)	Call DuckDB function quantile.
quantile_cont(...)	Call DuckDB function quantile_cont.
quantile_cont_filter(...)	Call DuckDB function quantile_cont with FILTER.
quantile_disc(...)	Call DuckDB function quantile_disc.
quantile_disc_filter(...)	Call DuckDB function quantile_disc with FILTER.
quantile_filter(...)	Call DuckDB function quantile with FILTER.
first(→ duckplus.static_typed.expression.TypedExpression)	Call DuckDB function first.
first_filter(...)	Call DuckDB function first with FILTER.
avg(→ duckplus.static_typed.expression.TypedExpression)	Call DuckDB function avg.
avg_filter(...)	Call DuckDB function avg with FILTER.
mean(→ duckplus.static_typed.expression.TypedExpression)	Call DuckDB function mean.
mean_filter(...)	Call DuckDB function mean with FILTER.
sum(→ duckplus.static_typed.expression.NumericExpression)	Call DuckDB function sum.
sum_filter(...)	Call DuckDB function sum with FILTER.
product(...)	Call DuckDB function product.
product_filter(...)	Call DuckDB function product with FILTER.
string_agg(...)	Call DuckDB function string_agg.
string_agg_filter(...)	Call DuckDB function string_agg with FILTER.
skewness(...)	Call DuckDB function skewness.
skewness_filter(...)	Call DuckDB function skewness with FILTER.
covar_pop(...)	Call DuckDB function covar_pop.
covar_pop_filter(...)	Call DuckDB function covar_pop with FILTER.
covar_samp(...)	Call DuckDB function covar_samp.
covar_samp_filter(...)	Call DuckDB function covar_samp with FILTER.
regr_avgx(...)	Call DuckDB function regr_avgx.
regr_avgx_filter(...)	Call DuckDB function regr_avgx with FILTER.
regr_avgy(...)	Call DuckDB function regr_avgy.
regr_avgy_filter(...)	Call DuckDB function regr_avgy with FILTER.
regr_count(...)	Call DuckDB function regr_count.
regr_count_filter(...)	Call DuckDB function regr_count with FILTER.
regr_intercept(...)	Call DuckDB function regr_intercept.
regr_intercept_filter(...)	Call DuckDB function regr_intercept with FILTER.
regr_r2(→ duckplus.static_typed.expression.TypedExpression)	Call DuckDB function regr_r2.
regr_r2_filter(...)	Call DuckDB function regr_r2 with FILTER.
regr_slope(...)	Call DuckDB function regr_slope.
regr_slope_filter(...)	Call DuckDB function regr_slope with FILTER.
regr_sxx(...)	Call DuckDB function regr_sxx.
regr_sxx_filter(...)	Call DuckDB function regr_sxx with FILTER.
regr_sxy(...)	Call DuckDB function regr_sxy.
regr_sxy_filter(...)	Call DuckDB function regr_sxy with FILTER.
regr_syy(...)	Call DuckDB function regr_syy.
regr_syy_filter(...)	Call DuckDB function regr_syy with FILTER.
array_append(...)	Append an element to the end of an array.
array_intersect(...)	Return the intersection of two arrays.
array_pop_back(...)	Drop the final element from an array.
array_pop_front(...)	Drop the first element from an array.
array_prepend(...)	Insert an element at the beginning of an array.
array_push_back(...)	Push an element onto the end of an array.
array_push_front(...)	Push an element onto the front of an array.
array_reverse(...)	Reverse the order of elements within an array.
array_to_string(...)	Join array elements into a string using the supplied separator.
array_to_string_comma_default(...)	Join array elements with a comma separator when none is provided.
current_catalog(...)	Return the name of the catalog for the active connection.
current_database(...)	Return the active database name for the current session.
current_query(...)	Return the SQL text of the query currently executing.
current_role(...)	Return the name of the active role (DuckDB always reports duckdb).
current_schema(...)	Return the name of the default schema for new relations.
current_schemas(...)	Return the visible schema search path as an array of names.
current_user(...)	Return the name of the authenticated user (always duckdb).
session_user(...)	Return the session user (DuckDB always reports duckdb).
split_part(...)	Split a string by delimiter and return the 1-indexed part.
pg_get_constraintdef(...)	Render the definition of a constraint from DuckDB's catalog.
pg_get_viewdef(...)	Return the SQL definition of the view identified by oid.
pg_size_pretty(...)	Format a byte count using PostgreSQL's pretty-printing convention.
pg_typeof(...)	Report the DuckDB logical type of expression in PostgreSQL form.
has_any_column_privilege(...)	Return TRUE for PostgreSQL column privilege checks.
has_column_privilege(...)	Return TRUE for PostgreSQL column-level privilege checks.
has_database_privilege(...)	Return TRUE for PostgreSQL database privilege checks.
has_foreign_data_wrapper_privilege(...)	Return TRUE for PostgreSQL foreign data wrapper privilege checks.
has_function_privilege(...)	Return TRUE for PostgreSQL function privilege checks.
has_language_privilege(...)	Return TRUE for PostgreSQL language privilege checks.
has_schema_privilege(...)	Return TRUE for PostgreSQL schema privilege checks.
has_sequence_privilege(...)	Return TRUE for PostgreSQL sequence privilege checks.
has_server_privilege(...)	Return TRUE for PostgreSQL server privilege checks.
has_table_privilege(...)	Return TRUE for PostgreSQL table privilege checks.
has_tablespace_privilege(...)	Return TRUE for PostgreSQL tablespace privilege checks.
pg_collation_is_visible(...)	Return TRUE when the collation identifier is visible.
pg_conversion_is_visible(...)	Return TRUE when the conversion identifier is visible.
pg_function_is_visible(...)	Return TRUE when the function identifier is visible.
pg_has_role(...)	Return TRUE when the requested role privilege is available.
pg_opclass_is_visible(...)	Return TRUE when the operator class identifier is visible.
pg_operator_is_visible(...)	Return TRUE when the operator identifier is visible.
pg_opfamily_is_visible(...)	Return TRUE when the operator family identifier is visible.
pg_table_is_visible(...)	Return TRUE when the table identifier is visible.
pg_ts_config_is_visible(...)	Return TRUE when the text search config identifier is visible.
pg_ts_dict_is_visible(...)	Return TRUE when the text search dictionary identifier is visible.
pg_ts_parser_is_visible(...)	Return TRUE when the text search parser identifier is visible.
pg_ts_template_is_visible(...)	Return TRUE when the text search template identifier is visible.
pg_type_is_visible(...)	Return TRUE when the type identifier is visible.

Package Contents

duckplus.functions.approx_count_distinct(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function approx_count_distinct.

Computes the approximate count of distinct elements using HyperLogLog.

Overloads: - main.approx_count_distinct(ANY any) -> BIGINT

duckplus.functions.approx_count_distinct_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function approx_count_distinct with FILTER.

Computes the approximate count of distinct elements using HyperLogLog.

Overloads: - main.approx_count_distinct(ANY any) -> BIGINT

duckplus.functions.approx_quantile_generic(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function approx_quantile.

Computes the approximate quantile using T-Digest.

Overloads: - main.approx_quantile(DATE x, FLOAT pos) -> DATE - main.approx_quantile(TIME x, FLOAT pos) -> TIME - main.approx_quantile(TIME WITH TIME ZONE x, FLOAT pos) -> TIME WITH TIME ZONE - main.approx_quantile(TIMESTAMP x, FLOAT pos) -> TIMESTAMP - main.approx_quantile(TIMESTAMP WITH TIME ZONE x, FLOAT pos) -> TIMESTAMP WITH TIME ZONE - main.approx_quantile(DATE x, FLOAT[] pos) -> DATE[] - main.approx_quantile(TIME x, FLOAT[] pos) -> TIME[] - main.approx_quantile(TIME WITH TIME ZONE x, FLOAT[] pos) -> TIME WITH TIME ZONE[] - main.approx_quantile(TIMESTAMP x, FLOAT[] pos) -> TIMESTAMP[] - main.approx_quantile(TIMESTAMP WITH TIME ZONE x, FLOAT[] pos) -> TIMESTAMP WITH TIME ZONE[]

duckplus.functions.approx_quantile_generic_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function approx_quantile with FILTER.

Computes the approximate quantile using T-Digest.

Overloads: - main.approx_quantile(DATE x, FLOAT pos) -> DATE - main.approx_quantile(TIME x, FLOAT pos) -> TIME - main.approx_quantile(TIME WITH TIME ZONE x, FLOAT pos) -> TIME WITH TIME ZONE - main.approx_quantile(TIMESTAMP x, FLOAT pos) -> TIMESTAMP - main.approx_quantile(TIMESTAMP WITH TIME ZONE x, FLOAT pos) -> TIMESTAMP WITH TIME ZONE - main.approx_quantile(DATE x, FLOAT[] pos) -> DATE[] - main.approx_quantile(TIME x, FLOAT[] pos) -> TIME[] - main.approx_quantile(TIME WITH TIME ZONE x, FLOAT[] pos) -> TIME WITH TIME ZONE[] - main.approx_quantile(TIMESTAMP x, FLOAT[] pos) -> TIMESTAMP[] - main.approx_quantile(TIMESTAMP WITH TIME ZONE x, FLOAT[] pos) -> TIMESTAMP WITH TIME ZONE[]

duckplus.functions.approx_quantile_numeric(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function approx_quantile.

Computes the approximate quantile using T-Digest.

Overloads: - main.approx_quantile(DECIMAL x, FLOAT pos) -> DECIMAL - main.approx_quantile(SMALLINT x, FLOAT pos) -> SMALLINT - main.approx_quantile(INTEGER x, FLOAT pos) -> INTEGER - main.approx_quantile(BIGINT x, FLOAT pos) -> BIGINT - main.approx_quantile(HUGEINT x, FLOAT pos) -> HUGEINT - main.approx_quantile(DOUBLE x, FLOAT pos) -> DOUBLE - main.approx_quantile(DECIMAL x, FLOAT[] pos) -> DECIMAL[] - main.approx_quantile(TINYINT x, FLOAT[] pos) -> TINYINT[] - main.approx_quantile(SMALLINT x, FLOAT[] pos) -> SMALLINT[] - main.approx_quantile(INTEGER x, FLOAT[] pos) -> INTEGER[] - main.approx_quantile(BIGINT x, FLOAT[] pos) -> BIGINT[] - main.approx_quantile(HUGEINT x, FLOAT[] pos) -> HUGEINT[] - main.approx_quantile(FLOAT x, FLOAT[] pos) -> FLOAT[] - main.approx_quantile(DOUBLE x, FLOAT[] pos) -> DOUBLE[]

duckplus.functions.approx_quantile_numeric_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function approx_quantile with FILTER.

Computes the approximate quantile using T-Digest.

Overloads: - main.approx_quantile(DECIMAL x, FLOAT pos) -> DECIMAL - main.approx_quantile(SMALLINT x, FLOAT pos) -> SMALLINT - main.approx_quantile(INTEGER x, FLOAT pos) -> INTEGER - main.approx_quantile(BIGINT x, FLOAT pos) -> BIGINT - main.approx_quantile(HUGEINT x, FLOAT pos) -> HUGEINT - main.approx_quantile(DOUBLE x, FLOAT pos) -> DOUBLE - main.approx_quantile(DECIMAL x, FLOAT[] pos) -> DECIMAL[] - main.approx_quantile(TINYINT x, FLOAT[] pos) -> TINYINT[] - main.approx_quantile(SMALLINT x, FLOAT[] pos) -> SMALLINT[] - main.approx_quantile(INTEGER x, FLOAT[] pos) -> INTEGER[] - main.approx_quantile(BIGINT x, FLOAT[] pos) -> BIGINT[] - main.approx_quantile(HUGEINT x, FLOAT[] pos) -> HUGEINT[] - main.approx_quantile(FLOAT x, FLOAT[] pos) -> FLOAT[] - main.approx_quantile(DOUBLE x, FLOAT[] pos) -> DOUBLE[]

duckplus.functions.approx_top_k(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function approx_top_k.

Finds the k approximately most occurring values in the data set

Overloads: - main.approx_top_k(ANY val, BIGINT k) -> ANY[]

duckplus.functions.approx_top_k_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function approx_top_k with FILTER.

Finds the k approximately most occurring values in the data set

Overloads: - main.approx_top_k(ANY val, BIGINT k) -> ANY[]

duckplus.functions.histogram(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function histogram.

Returns a LIST of STRUCTs with the fields bucket and count.

Overloads: - main.histogram(ANY arg) -> MAP - main.histogram(ANY arg, ANY[] col1) -> MAP

duckplus.functions.histogram_exact(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function histogram_exact.

Returns a LIST of STRUCTs with the fields bucket and count matching the buckets exactly.

Overloads: - main.histogram_exact(ANY arg, ANY[] bins) -> MAP

duckplus.functions.histogram_exact_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function histogram_exact with FILTER.

Returns a LIST of STRUCTs with the fields bucket and count matching the buckets exactly.

Overloads: - main.histogram_exact(ANY arg, ANY[] bins) -> MAP

duckplus.functions.histogram_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function histogram with FILTER.

Returns a LIST of STRUCTs with the fields bucket and count.

Overloads: - main.histogram(ANY arg) -> MAP - main.histogram(ANY arg, ANY[] col1) -> MAP

duckplus.functions.arg_max(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

duckplus.functions.arg_max_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

duckplus.functions.arg_max_null(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

duckplus.functions.arg_max_null_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

duckplus.functions.arg_min(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

duckplus.functions.arg_min_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

duckplus.functions.arg_min_null(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

duckplus.functions.arg_min_null_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

duckplus.functions.max_by(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

duckplus.functions.max_by_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

duckplus.functions.min_by(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

duckplus.functions.min_by_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

duckplus.functions.max(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function max.

duckplus.functions.max_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function max with FILTER.

duckplus.functions.min(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function min.

duckplus.functions.min_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function min with FILTER.

duckplus.functions.bool_and(self: duckplus.static_typed._generated_function_namespaces.AggregateBooleanFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.BooleanExpression

Call DuckDB function bool_and.

Returns TRUE if every input value is TRUE, otherwise FALSE.

Overloads: - main.bool_and(BOOLEAN arg) -> BOOLEAN

duckplus.functions.bool_and_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateBooleanFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.BooleanExpression

Call DuckDB function bool_and with FILTER.

Returns TRUE if every input value is TRUE, otherwise FALSE.

Overloads: - main.bool_and(BOOLEAN arg) -> BOOLEAN

duckplus.functions.bool_or(self: duckplus.static_typed._generated_function_namespaces.AggregateBooleanFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.BooleanExpression

Call DuckDB function bool_or.

Returns TRUE if any input value is TRUE, otherwise FALSE.

Overloads: - main.bool_or(BOOLEAN arg) -> BOOLEAN

duckplus.functions.bool_or_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateBooleanFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.BooleanExpression

Call DuckDB function bool_or with FILTER.

Returns TRUE if any input value is TRUE, otherwise FALSE.

Overloads: - main.bool_or(BOOLEAN arg) -> BOOLEAN

duckplus.functions.bit_and(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function bit_and.

Returns the bitwise AND of all bits in a given expression.

Overloads: - main.bit_and(TINYINT arg) -> TINYINT - main.bit_and(SMALLINT arg) -> SMALLINT - main.bit_and(INTEGER arg) -> INTEGER - main.bit_and(BIGINT arg) -> BIGINT - main.bit_and(HUGEINT arg) -> HUGEINT - main.bit_and(UTINYINT arg) -> UTINYINT - main.bit_and(USMALLINT arg) -> USMALLINT - main.bit_and(UINTEGER arg) -> UINTEGER - main.bit_and(UBIGINT arg) -> UBIGINT

duckplus.functions.bit_and_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function bit_and with FILTER.

Returns the bitwise AND of all bits in a given expression.

Overloads: - main.bit_and(TINYINT arg) -> TINYINT - main.bit_and(SMALLINT arg) -> SMALLINT - main.bit_and(INTEGER arg) -> INTEGER - main.bit_and(BIGINT arg) -> BIGINT - main.bit_and(HUGEINT arg) -> HUGEINT - main.bit_and(UTINYINT arg) -> UTINYINT - main.bit_and(USMALLINT arg) -> USMALLINT - main.bit_and(UINTEGER arg) -> UINTEGER - main.bit_and(UBIGINT arg) -> UBIGINT

duckplus.functions.bit_or(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function bit_or.

Returns the bitwise OR of all bits in a given expression.

Overloads: - main.bit_or(TINYINT arg) -> TINYINT - main.bit_or(SMALLINT arg) -> SMALLINT - main.bit_or(INTEGER arg) -> INTEGER - main.bit_or(BIGINT arg) -> BIGINT - main.bit_or(HUGEINT arg) -> HUGEINT - main.bit_or(UTINYINT arg) -> UTINYINT - main.bit_or(USMALLINT arg) -> USMALLINT - main.bit_or(UINTEGER arg) -> UINTEGER - main.bit_or(UBIGINT arg) -> UBIGINT

duckplus.functions.bit_or_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function bit_or with FILTER.

Returns the bitwise OR of all bits in a given expression.

Overloads: - main.bit_or(TINYINT arg) -> TINYINT - main.bit_or(SMALLINT arg) -> SMALLINT - main.bit_or(INTEGER arg) -> INTEGER - main.bit_or(BIGINT arg) -> BIGINT - main.bit_or(HUGEINT arg) -> HUGEINT - main.bit_or(UTINYINT arg) -> UTINYINT - main.bit_or(USMALLINT arg) -> USMALLINT - main.bit_or(UINTEGER arg) -> UINTEGER - main.bit_or(UBIGINT arg) -> UBIGINT

duckplus.functions.bit_xor(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function bit_xor.

Returns the bitwise XOR of all bits in a given expression.

Overloads: - main.bit_xor(TINYINT arg) -> TINYINT - main.bit_xor(SMALLINT arg) -> SMALLINT - main.bit_xor(INTEGER arg) -> INTEGER - main.bit_xor(BIGINT arg) -> BIGINT - main.bit_xor(HUGEINT arg) -> HUGEINT - main.bit_xor(UTINYINT arg) -> UTINYINT - main.bit_xor(USMALLINT arg) -> USMALLINT - main.bit_xor(UINTEGER arg) -> UINTEGER - main.bit_xor(UBIGINT arg) -> UBIGINT

duckplus.functions.bit_xor_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function bit_xor with FILTER.

Returns the bitwise XOR of all bits in a given expression.

Overloads: - main.bit_xor(TINYINT arg) -> TINYINT - main.bit_xor(SMALLINT arg) -> SMALLINT - main.bit_xor(INTEGER arg) -> INTEGER - main.bit_xor(BIGINT arg) -> BIGINT - main.bit_xor(HUGEINT arg) -> HUGEINT - main.bit_xor(UTINYINT arg) -> UTINYINT - main.bit_xor(USMALLINT arg) -> USMALLINT - main.bit_xor(UINTEGER arg) -> UINTEGER - main.bit_xor(UBIGINT arg) -> UBIGINT

duckplus.functions.bitstring_agg(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function bitstring_agg.

duckplus.functions.bitstring_agg_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function bitstring_agg with FILTER.

duckplus.functions.count(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function count.

Returns the number of non-NULL values in arg.

Overloads: - main.count() -> BIGINT - main.count(ANY arg) -> BIGINT

duckplus.functions.count_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function count with FILTER.

Returns the number of non-NULL values in arg.

Overloads: - main.count() -> BIGINT - main.count(ANY arg) -> BIGINT

duckplus.functions.count_if(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function count_if.

Counts the total number of TRUE values for a boolean column

Overloads: - main.count_if(BOOLEAN arg) -> HUGEINT

duckplus.functions.count_if_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function count_if with FILTER.

Counts the total number of TRUE values for a boolean column

Overloads: - main.count_if(BOOLEAN arg) -> HUGEINT

duckplus.functions.count_star(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function count_star.

Overloads: - main.count_star() -> BIGINT

duckplus.functions.count_star_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function count_star with FILTER.

Overloads: - main.count_star() -> BIGINT

duckplus.functions.countif(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function countif.

Counts the total number of TRUE values for a boolean column

Overloads: - main.countif(BOOLEAN arg) -> HUGEINT

duckplus.functions.countif_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function countif with FILTER.

Counts the total number of TRUE values for a boolean column

Overloads: - main.countif(BOOLEAN arg) -> HUGEINT

duckplus.functions.any_value(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function any_value.

Returns the first non-NULL value from arg. This function is affected by ordering.

Overloads: - main.any_value(ANY arg) -> ANY

duckplus.functions.any_value_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function any_value with FILTER.

Returns the first non-NULL value from arg. This function is affected by ordering.

Overloads: - main.any_value(ANY arg) -> ANY

duckplus.functions.list_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function list with FILTER.

Returns a LIST containing all the values of a column.

Overloads: - main.list(T arg) -> T[]

duckplus.functions.median_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function median with FILTER.

Returns the middle value of the set. NULL values are ignored. For even value counts, interpolate-able types (numeric, date/time) return the average of the two middle values. Non-interpolate-able types (everything else) return the lower of the two middle values.

Overloads: - main.median(ANY x) -> ANY

duckplus.functions.mode_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function mode with FILTER.

Returns the most frequent value for the values within x. NULL values are ignored.

Overloads: - main.mode(ANY x) -> ANY

duckplus.functions.quantile(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function quantile.

duckplus.functions.quantile_cont(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function quantile_cont.

duckplus.functions.quantile_cont_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function quantile_cont with FILTER.

duckplus.functions.quantile_disc(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function quantile_disc.

duckplus.functions.quantile_disc_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function quantile_disc with FILTER.

duckplus.functions.quantile_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function quantile with FILTER.

duckplus.functions.first(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function first.

Returns the first value (NULL or non-NULL) from arg. This function is affected by ordering.

Overloads: - main.first(ANY arg) -> ANY

duckplus.functions.first_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function first with FILTER.

Returns the first value (NULL or non-NULL) from arg. This function is affected by ordering.

Overloads: - main.first(ANY arg) -> ANY

duckplus.functions.avg(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function avg.

duckplus.functions.avg_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function avg with FILTER.

duckplus.functions.mean(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function mean.

duckplus.functions.mean_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function mean with FILTER.

duckplus.functions.sum(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function sum.

duckplus.functions.sum_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function sum with FILTER.

duckplus.functions.product(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function product.

duckplus.functions.product_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function product with FILTER.

duckplus.functions.string_agg(self: duckplus.static_typed._generated_function_namespaces.AggregateVarcharFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.VarcharExpression

Call DuckDB function string_agg.

Concatenates the column string values with an optional separator.

Overloads: - main.string_agg(ANY str) -> VARCHAR - main.string_agg(ANY str, VARCHAR arg) -> VARCHAR

duckplus.functions.string_agg_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateVarcharFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.VarcharExpression

Call DuckDB function string_agg with FILTER.

Concatenates the column string values with an optional separator.

Overloads: - main.string_agg(ANY str) -> VARCHAR - main.string_agg(ANY str, VARCHAR arg) -> VARCHAR

duckplus.functions.skewness(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function skewness.

Returns the skewness of all input values.

Overloads: - main.skewness(DOUBLE x) -> DOUBLE

duckplus.functions.skewness_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateNumericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.NumericExpression

Call DuckDB function skewness with FILTER.

Returns the skewness of all input values.

Overloads: - main.skewness(DOUBLE x) -> DOUBLE

duckplus.functions.covar_pop(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function covar_pop.

duckplus.functions.covar_pop_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function covar_pop with FILTER.

duckplus.functions.covar_samp(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function covar_samp.

duckplus.functions.covar_samp_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function covar_samp with FILTER.

duckplus.functions.regr_avgx(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_avgx.

duckplus.functions.regr_avgx_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_avgx with FILTER.

duckplus.functions.regr_avgy(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_avgy.

duckplus.functions.regr_avgy_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_avgy with FILTER.

duckplus.functions.regr_count(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_count.

duckplus.functions.regr_count_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_count with FILTER.

duckplus.functions.regr_intercept(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_intercept.

duckplus.functions.regr_intercept_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_intercept with FILTER.

duckplus.functions.regr_r2(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_r2.

duckplus.functions.regr_r2_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_r2 with FILTER.

duckplus.functions.regr_slope(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_slope.

duckplus.functions.regr_slope_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_slope with FILTER.

duckplus.functions.regr_sxx(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_sxx.

duckplus.functions.regr_sxx_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_sxx with FILTER.

duckplus.functions.regr_sxy(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_sxy.

duckplus.functions.regr_sxy_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_sxy with FILTER.

duckplus.functions.regr_syy(self: Any, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_syy.

duckplus.functions.regr_syy_filter(self: Any, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function regr_syy with FILTER.

duckplus.functions.array_append(self: duckplus.static_typed._generated_function_namespaces.ScalarGenericFunctions, *operands: object) → duckplus.static_typed.expression.GenericExpression

Append an element to the end of an array.

duckplus.functions.array_intersect(self: duckplus.static_typed._generated_function_namespaces.ScalarGenericFunctions, *operands: object) → duckplus.static_typed.expression.GenericExpression

Return the intersection of two arrays.

duckplus.functions.array_pop_back(self: duckplus.static_typed._generated_function_namespaces.ScalarGenericFunctions, *operands: object) → duckplus.static_typed.expression.GenericExpression

Drop the final element from an array.

duckplus.functions.array_pop_front(self: duckplus.static_typed._generated_function_namespaces.ScalarGenericFunctions, *operands: object) → duckplus.static_typed.expression.GenericExpression

Drop the first element from an array.

duckplus.functions.array_prepend(self: duckplus.static_typed._generated_function_namespaces.ScalarGenericFunctions, *operands: object) → duckplus.static_typed.expression.GenericExpression

Insert an element at the beginning of an array.

duckplus.functions.array_push_back(self: duckplus.static_typed._generated_function_namespaces.ScalarGenericFunctions, *operands: object) → duckplus.static_typed.expression.GenericExpression

Push an element onto the end of an array.

duckplus.functions.array_push_front(self: duckplus.static_typed._generated_function_namespaces.ScalarGenericFunctions, *operands: object) → duckplus.static_typed.expression.GenericExpression

Push an element onto the front of an array.

duckplus.functions.array_reverse(self: duckplus.static_typed._generated_function_namespaces.ScalarGenericFunctions, *operands: object) → duckplus.static_typed.expression.GenericExpression

Reverse the order of elements within an array.

duckplus.functions.array_to_string(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Join array elements into a string using the supplied separator.

Overloads: - main.array_to_string(ANY arr, ANY sep) -> VARCHAR

duckplus.functions.array_to_string_comma_default(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Join array elements with a comma separator when none is provided.

Overloads: - main.array_to_string_comma_default(ANY arr, ANY sep) -> VARCHAR

duckplus.functions.current_catalog(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Return the name of the catalog for the active connection.

duckplus.functions.current_database(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Return the active database name for the current session.

duckplus.functions.current_query(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Return the SQL text of the query currently executing.

duckplus.functions.current_role(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Return the name of the active role (DuckDB always reports duckdb).

duckplus.functions.current_schema(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Return the name of the default schema for new relations.

duckplus.functions.current_schemas(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Return the visible schema search path as an array of names.

duckplus.functions.current_user(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Return the name of the authenticated user (always duckdb).

duckplus.functions.session_user(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Return the session user (DuckDB always reports duckdb).

duckplus.functions.split_part(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Split a string by delimiter and return the 1-indexed part.

Overloads: - main.split_part(ANY string, ANY delimiter, ANY position) -> VARCHAR

duckplus.functions.pg_get_constraintdef(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Render the definition of a constraint from DuckDB’s catalog.

duckplus.functions.pg_get_viewdef(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Return the SQL definition of the view identified by oid.

duckplus.functions.pg_size_pretty(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Format a byte count using PostgreSQL’s pretty-printing convention.

duckplus.functions.pg_typeof(self: duckplus.static_typed._generated_function_namespaces.ScalarVarcharFunctions, *operands: object) → duckplus.static_typed.expression.VarcharExpression

Report the DuckDB logical type of expression in PostgreSQL form.

duckplus.functions.has_any_column_privilege(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE for PostgreSQL column privilege checks.

Overloads: - pg_catalog.has_any_column_privilege(ANY table, ANY privilege) -> BOOLEAN - pg_catalog.has_any_column_privilege(ANY user, ANY table, ANY privilege) -> BOOLEAN

duckplus.functions.has_column_privilege(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE for PostgreSQL column-level privilege checks.

Overloads: - pg_catalog.has_column_privilege(ANY table, ANY column, ANY privilege) -> BOOLEAN - pg_catalog.has_column_privilege(ANY user, ANY table, ANY column, ANY privilege) -> BOOLEAN

duckplus.functions.has_database_privilege(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE for PostgreSQL database privilege checks.

Overloads: - pg_catalog.has_database_privilege(ANY database, ANY privilege) -> BOOLEAN - pg_catalog.has_database_privilege(ANY user, ANY database, ANY privilege) -> BOOLEAN

duckplus.functions.has_foreign_data_wrapper_privilege(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE for PostgreSQL foreign data wrapper privilege checks.

Overloads: - pg_catalog.has_foreign_data_wrapper_privilege(ANY fdw, ANY privilege) -> BOOLEAN - pg_catalog.has_foreign_data_wrapper_privilege(ANY user, ANY fdw, ANY privilege) -> BOOLEAN

duckplus.functions.has_function_privilege(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE for PostgreSQL function privilege checks.

Overloads: - pg_catalog.has_function_privilege(ANY function, ANY privilege) -> BOOLEAN - pg_catalog.has_function_privilege(ANY user, ANY function, ANY privilege) -> BOOLEAN

duckplus.functions.has_language_privilege(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE for PostgreSQL language privilege checks.

Overloads: - pg_catalog.has_language_privilege(ANY language, ANY privilege) -> BOOLEAN - pg_catalog.has_language_privilege(ANY user, ANY language, ANY privilege) -> BOOLEAN

duckplus.functions.has_schema_privilege(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE for PostgreSQL schema privilege checks.

Overloads: - pg_catalog.has_schema_privilege(ANY schema, ANY privilege) -> BOOLEAN - pg_catalog.has_schema_privilege(ANY user, ANY schema, ANY privilege) -> BOOLEAN

duckplus.functions.has_sequence_privilege(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE for PostgreSQL sequence privilege checks.

Overloads: - pg_catalog.has_sequence_privilege(ANY sequence, ANY privilege) -> BOOLEAN - pg_catalog.has_sequence_privilege(ANY user, ANY sequence, ANY privilege) -> BOOLEAN

duckplus.functions.has_server_privilege(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE for PostgreSQL server privilege checks.

Overloads: - pg_catalog.has_server_privilege(ANY server, ANY privilege) -> BOOLEAN - pg_catalog.has_server_privilege(ANY user, ANY server, ANY privilege) -> BOOLEAN

duckplus.functions.has_table_privilege(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE for PostgreSQL table privilege checks.

Overloads: - pg_catalog.has_table_privilege(ANY table, ANY privilege) -> BOOLEAN - pg_catalog.has_table_privilege(ANY user, ANY table, ANY privilege) -> BOOLEAN

duckplus.functions.has_tablespace_privilege(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE for PostgreSQL tablespace privilege checks.

Overloads: - pg_catalog.has_tablespace_privilege(ANY tablespace, ANY privilege) -> BOOLEAN - pg_catalog.has_tablespace_privilege(ANY user, ANY tablespace, ANY privilege) -> BOOLEAN

duckplus.functions.pg_collation_is_visible(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE when the collation identifier is visible.

duckplus.functions.pg_conversion_is_visible(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE when the conversion identifier is visible.

duckplus.functions.pg_function_is_visible(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE when the function identifier is visible.

duckplus.functions.pg_has_role(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE when the requested role privilege is available.

duckplus.functions.pg_opclass_is_visible(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE when the operator class identifier is visible.

duckplus.functions.pg_operator_is_visible(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE when the operator identifier is visible.

duckplus.functions.pg_opfamily_is_visible(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE when the operator family identifier is visible.

duckplus.functions.pg_table_is_visible(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE when the table identifier is visible.

duckplus.functions.pg_ts_config_is_visible(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE when the text search config identifier is visible.

duckplus.functions.pg_ts_dict_is_visible(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE when the text search dictionary identifier is visible.

duckplus.functions.pg_ts_parser_is_visible(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE when the text search parser identifier is visible.

duckplus.functions.pg_ts_template_is_visible(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE when the text search template identifier is visible.

duckplus.functions.pg_type_is_visible(self: duckplus.static_typed._generated_function_namespaces.ScalarBooleanFunctions, *operands: object) → duckplus.static_typed.expression.BooleanExpression

Return TRUE when the type identifier is visible.

duckplus.functions.SIDE_EFFECT_MODULES: tuple[str, Ellipsis] = ('duckplus.functions.aggregate', 'duckplus.functions.aggregate.approximation',...