cube.js 也支持join,
joins: {
  TargetCubeName: {
    relationship: `belongsTo` || `hasMany` || `hasOne`,
    sql: `SQL ON clause`
  }
}
cube("Authors", {
  joins: {
    Books: {
      relationship: `hasMany`,
      sql: `${Authors}.id = ${Books}.author_id`
    }
  }
});
详细的可以参考官方文档,都是一些基本的配置
原文:https://www.cnblogs.com/rongfengliang/p/10804373.html