duckplus.functions.aggregate

Aggregate DuckDB function helpers organised by domain.

Submodules

• duckplus.functions.aggregate.approximation
• duckplus.functions.aggregate.arg_extrema
• duckplus.functions.aggregate.averages
• duckplus.functions.aggregate.bitstring
• duckplus.functions.aggregate.bitwise
• duckplus.functions.aggregate.boolean
• duckplus.functions.aggregate.counting
• duckplus.functions.aggregate.extrema
• duckplus.functions.aggregate.extremum_by_value
• duckplus.functions.aggregate.generic
• duckplus.functions.aggregate.list
• duckplus.functions.aggregate.map
• duckplus.functions.aggregate.median
• duckplus.functions.aggregate.mode
• duckplus.functions.aggregate.ordering
• duckplus.functions.aggregate.quantiles
• duckplus.functions.aggregate.regression
• duckplus.functions.aggregate.statistics
• duckplus.functions.aggregate.string
• duckplus.functions.aggregate.summation

Attributes

approximation
arg_extrema
extremum_by_value
extrema_module
boolean
bitwise
bitstring_module
counting
generic
list_module
map_module
median_module
mode_module
quantiles_module
ordering
summation
string_module
statistics
averages_module
regression_module
list
map
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(→ duckplus.static_typed.expression.TypedExpression)	Call DuckDB function median.
median_filter(...)	Call DuckDB function median with FILTER.
mode(→ duckplus.static_typed.expression.TypedExpression)	Call DuckDB function mode.
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.
product(...)	Call DuckDB function product.
product_filter(...)	Call DuckDB function product with FILTER.
sum(→ duckplus.static_typed.expression.NumericExpression)	Call DuckDB function sum.
sum_filter(...)	Call DuckDB function sum 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.
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.
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.

Package Contents

duckplus.functions.aggregate.approximation: types.ModuleType

duckplus.functions.aggregate.arg_extrema: types.ModuleType

duckplus.functions.aggregate.extremum_by_value: types.ModuleType

duckplus.functions.aggregate.extrema_module: types.ModuleType

duckplus.functions.aggregate.boolean: types.ModuleType

duckplus.functions.aggregate.bitwise: types.ModuleType

duckplus.functions.aggregate.bitstring_module: types.ModuleType

duckplus.functions.aggregate.counting: types.ModuleType

duckplus.functions.aggregate.generic: types.ModuleType

duckplus.functions.aggregate.list_module: types.ModuleType

duckplus.functions.aggregate.map_module: types.ModuleType

duckplus.functions.aggregate.median_module: types.ModuleType

duckplus.functions.aggregate.mode_module: types.ModuleType

duckplus.functions.aggregate.quantiles_module: types.ModuleType

duckplus.functions.aggregate.ordering: types.ModuleType

duckplus.functions.aggregate.summation: types.ModuleType

duckplus.functions.aggregate.string_module: types.ModuleType

duckplus.functions.aggregate.statistics: types.ModuleType

duckplus.functions.aggregate.averages_module: types.ModuleType

duckplus.functions.aggregate.regression_module: types.ModuleType

duckplus.functions.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.median(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 median.

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.aggregate.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.aggregate.mode(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 mode.

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

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

duckplus.functions.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.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.aggregate.list

duckplus.functions.aggregate.map

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