sum method
Get sum of a column
Implementation
Future<num?> sum(String column) async {
final sql = _buildAggregateSql('SUM', column);
final result = await repository.connection.query(sql, parameters: _params);
if (result.isEmpty) return null;
final value = result.first['sum_value'];
return value != null ? (value as num) : null;
}