Method finalize

packages/sql/src/query/QueryBuilder.ts:3701–3784

()

  }

  private finalize(): void {
    if (this.#state.finalized) {
      return;
    }

    if (!this.#state.type) {
      this.select('*');
    }

    const meta = this.mainAlias.meta as EntityMetadata<Entity>;
    this.applyDiscriminatorCondition();
    this.applyTPTJoins();
    this.addTPTParentFields();
    this.applyTPTPolymorphicJoins();
    this.processPopulateHint();
    this.processNestedJoins();

    if (meta && (this.#state.fields?.includes('*') || this.#state.fields?.includes(`${this.mainAlias.aliasName}.*`))) {
      const schema = this.getSchema(this.mainAlias);

      // Create a column mapping with unquoted aliases - quoting should be handled by the user via `quote` helper
      // For TPT, use helper to resolve correct alias per property (inherited props use parent alias)
      const quotedMainAlias = this.platform.quoteIdentifier(this.mainAlias.aliasName).toString();
      const columns = meta.createColumnMappingObject(
        prop => this.helper.getTPTAliasForProperty(prop.name, this.mainAlias.aliasName),
        quotedMainAlias,
      );

      meta.props
        .filter(prop => prop.formula && (!prop.lazy || this.#state.flags.has(QueryFlag.INCLUDE_LAZY_FORMULAS)))
        .map(prop => {
          const aliased = this.platform.quoteIdentifier(prop.fieldNames[0]);
          const table = this.helper.createFormulaTable(quotedMainAlias, meta, schema);
          return `${this.driver.evaluateFormula(prop.formula!, columns, table)} as ${aliased}`;
        })
        .filter(
          field =>
            !this.#state.fields!.some(f => {
              if (isRaw(f)) {
                return f.sql === field && f.params.length === 0;
              }

              return f === field;
            }),
        )
        .forEach(field => this.#state.fields!.push(raw(field)));
    }

    QueryHelper.processObjectParams(this.#state.data);
    QueryHelper.processObjectParams(this.#state.cond);
    QueryHelper.processObjectParams(this.#state.having);

    // automatically enable paginate flag when we detect to-many joins, but only if there is no `group by` clause
    if (
      !this.#state.flags.has(QueryFlag.DISABLE_PAGINATE) &&
      this.#state.groupBy.length === 0 &&
      this.hasToManyJoins()
    ) {