group method
Implementation
Future<DbResponse> group(
{required List<String> groupBy,
List<Column>? columns,
List<Aggregate>? aggregates,
Where? where,
OrderBy? orderBy}) async {
String query =
'SELECT ${columns == null ? "" : "${columns.map((val) => '"$val"').join(',')},"} ${aggregates == null ? "" : (aggregates.map((e) => e.query)).join(", ")} FROM "$tableName" ${getQuery(where: where, groupBy: groupBy, orderBy: orderBy)}';
var dbRes = await db.query(query);
return DbResponse(
dbRes.columnDescriptions.map((e) => e.columnName).toList(),
List<List>.from(dbRes.toList()));
}