join method
Implementation
Future<DbResponse> join(
{List<Column> columns = const [],
required List<Join> joins,
String? tableAs,
Where? where,
OrderBy? orderBy,
int? limit}) async {
String query =
'SELECT ${columns.isEmpty ? "*" : columns.map((val) => '"$val"').join(',')} FROM "$tableName" ${tableAs == null ? "" : "AS $tableAs"} ${joins.map(
(e) => e.query,
).join(" ")} ${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()));
}