Joins
{{if this.joins.length (concat this.joins.length " join" (if (gt this.joins.length 1) "s")) "No joins"}}
{{#if this.relationships.length}}
Available Relationships
{{#each this.relationships as |relationship|}}
{{relationship.label}}
{{relationship.table}} table
{{uppercase relationship.type}} JOIN
{{#if (this.isJoined relationship.key)}} {{#let (this.getJoinedRelationship relationship.key) as |joinedRel|}}
Select columns from {{relationship.label}}
{{joinedRel.selectedColumns.length}} selected
{{#each relationship.columns as |column|}}
{{column.label}}
{{column.type}}
{{#if (includes column.name (map-by "name" joinedRel.selectedColumns))}} {{/if}}
{{/each}}
{{/let}} {{/if}}
{{/each}}
{{#if (gt this.totalJoinedColumns 20)}}
Performance Warning
You have {{this.totalJoinedColumns}} joined columns selected. Consider selecting only the columns you need for better performance.
{{/if}} {{else}}
No relationships available
This table has no defined relationships to join with other tables
{{/if}}