nest.js如何写多表的查询呀？官网给的例子都是跟表一一对应的实例，满足不了需求。？

                SELECT AVG(sco_progress.raw_score) AS score_average
                FROM   sco_progress
                           INNER JOIN construct ON sco_progress.sco_id = construct.sco_id and sco_progress.course_id = construct.course_id
                           INNER JOIN sco_master ON sco_progress.sco_id = sco_master.sco_id
                WHERE  sco_progress.user_id = <cfqueryparam cfsqltype="cf_sql_integer" value="#user_id#" />
                AND    construct.course_id = <cfqueryparam cfsqltype="cf_sql_integer" value="#course_id#" />
                AND    sco_master.sco_type = 1
                AND       sco_progress.raw_score IS NOT NULL

比如我想做上面这样的查询。为什么不直接给一个js对象赋值就好了，还需要Entities呢？Entities不是跟表结构一模一样吗？