GroupingExtension<T extends OrmEntity> extension

Extension providing GROUP BY and HAVING clause methods for query results.

on

• Query<T>

Methods

groupBy(List<String> columns) → Query<T>

Available on Query<T>, provided by the GroupingExtension extension

Groups rows by the provided columns.

groupByExtension(String key, [Object? payload]) → Query<T>

Available on Query<T>, provided by the GroupingExtension extension

Adds a custom GROUP BY expression compiled by a driver extension.

having(String field, PredicateOperator operator, Object? value) → Query<T>

Available on Query<T>, provided by the GroupingExtension extension

Adds a HAVING predicate over grouped rows.

havingBitwise(String field, String operator, Object value) → Query<T>

Available on Query<T>, provided by the GroupingExtension extension

Adds a HAVING clause with a bitwise operator.

havingExtension(String key, [Object? payload]) → Query<T>

Available on Query<T>, provided by the GroupingExtension extension

Adds a custom HAVING predicate compiled by a driver extension.

havingRaw(String sql, [List<Object?> bindings = const []]) → Query<T>

Available on Query<T>, provided by the GroupingExtension extension

Adds a raw HAVING fragment.

limitPerGroup(int limit, String column, {int? offset}) → Query<T>

Available on Query<T>, provided by the GroupingExtension extension

Limits the number of rows returned per group.

orHavingBitwise(String field, String operator, Object value) → Query<T>

Available on Query<T>, provided by the GroupingExtension extension

Adds a HAVING clause with a bitwise operator using OR chaining.

orHavingExtension(String key, [Object? payload]) → Query<T>

Available on Query<T>, provided by the GroupingExtension extension

Adds a custom HAVING predicate using OR logic.

orHavingRaw(String sql, [List<Object?> bindings = const []]) → Query<T>

Available on Query<T>, provided by the GroupingExtension extension

Adds a raw HAVING fragment using OR logic.