select method
Implementation
Future<DbResponse> select({
Where? where,
OrderBy? orderBy,
List<Column> columns = const [],
bool distinct = false,
int? limit,
}) async {
// ignore: no_leading_underscores_for_local_identifiers
String _fields = columns.isEmpty ? '*' : columns.join(',');
String query =
'SELECT ${distinct ? "DISTINCT " : ''}$_fields FROM "$tableName" ${getQuery(where: where, orderBy: orderBy, limit: limit)}';
var dbRes = await db.query(query);
return DbResponse(
dbRes.columnDescriptions.map((e) => e.columnName).toList(),
List<List>.from(dbRes.toList()));
}