Method addPropertyJoin

packages/sql/src/query/QueryBuilder.ts:2991–3007

* Adds a join from a property object. Used internally for TPT joins where the property * is synthetic (not in entity.properties) but defined on metadata (e.g., tptParentProp). * The caller must create the alias first via createAlias(). * @internal

(
    prop: EntityProperty,
    ownerAlias: string,
    alias: string,
    type: JoinType,
    path: string,
    schema?: string,
  )

   * @internal
   */
  addPropertyJoin(
    prop: EntityProperty,
    ownerAlias: string,
    alias: string,
    type: JoinType,
    path: string,
    schema?: string,
  ): string {
    schema ??= prop.targetMeta?.schema === '*' ? '*' : this.driver.getSchemaName(prop.targetMeta);
    const key = `[tpt]${ownerAlias}#${alias}`;
    this.#state.joins[key] =
      prop.kind === ReferenceKind.MANY_TO_ONE
        ? this.helper.joinManyToOneReference(prop, ownerAlias, alias, type, {}, schema)
        : this.helper.joinOneToReference(prop, ownerAlias, alias, type, {}, schema);
    this.#state.joins[key].path = path;
    return key;
  }

  private joinReference(
    field: string | RawQueryFragment | NativeQueryBuilder | QueryBuilder,