as method

Implementation

@override
Query as() =>
    select([
      scores.id,
      scores.user,
      scores.semester,
      scores.score,
      scores.status,
      courses.code,
      courses.nameZh,
      courseOfferings.number,
    ]).from(scores).join([
      innerJoin(courses, courses.id.equalsExp(scores.course)),
      leftOuterJoin(
        courseOfferings,
        courseOfferings.id.equalsExp(scores.courseOffering),
      ),
    ]);