Function mapPropToFieldNames

packages/sql/src/AbstractSqlDriver.ts:2872–2930

* @internal

(
    qb: AnyQueryBuilder<T>,
    prop: EntityProperty<T>,
    tableAlias: string,
    meta: EntityMetadata<T>,
    schema?: string,
    explicitFields?: readonly InternalField<T>[],
  )

   * @internal
   */
  mapPropToFieldNames<T extends object>(
    qb: AnyQueryBuilder<T>,
    prop: EntityProperty<T>,
    tableAlias: string,
    meta: EntityMetadata<T>,
    schema?: string,
    explicitFields?: readonly InternalField<T>[],
  ): InternalField<T>[] {
    if (prop.kind === ReferenceKind.EMBEDDED && !prop.object) {
      return Object.entries(prop.embeddedProps).flatMap(([name, childProp]) => {
        const childFields = explicitFields ? Utils.extractChildElements(explicitFields as string[], prop.name) : [];

        if (
          !this.shouldHaveColumn(
            prop.targetMeta!,
            { ...childProp, name },
            [],
            childFields.length > 0 ? childFields : undefined,
          )
        ) {
          return [];
        }

        return this.mapPropToFieldNames<T>(qb, childProp, tableAlias, meta, schema, childFields);
      });
    }

    const aliased = this.platform.quoteIdentifier(`${tableAlias}__${prop.fieldNames[0]}`);
    const sourceAlias = qb.helper.getTPTAliasForProperty(prop.name, tableAlias);

    if (prop.customTypes?.some(type => !!type?.convertToJSValueSQL)) {
      return prop.fieldNames.map((col, idx) => {
        if (!prop.customTypes[idx]?.convertToJSValueSQL) {
          return col;
        }

        const prefixed = this.platform.quoteIdentifier(`${sourceAlias}.${col}`);
        const aliased = this.platform.quoteIdentifier(`${tableAlias}__${col}`);

        return raw(`${prop.customTypes[idx].convertToJSValueSQL(prefixed, this.platform)} as ${aliased}`);
      });
    }

    if (prop.customType?.convertToJSValueSQL) {
      const prefixed = this.platform.quoteIdentifier(`${sourceAlias}.${prop.fieldNames[0]}`);
      return [raw(`${prop.customType.convertToJSValueSQL(prefixed, this.platform)} as ${aliased}`)];
    }

    if (prop.formula) {
      const quotedAlias = this.platform.quoteIdentifier(tableAlias).toString();
      const table = this.createFormulaTable(quotedAlias, meta, schema);
      const columns = meta.createColumnMappingObject(tableAlias);
      return [raw(`${this.evaluateFormula(prop.formula, columns, table)} as ${aliased}`)];
    }

    return prop.fieldNames.map(fieldName => {
      return raw('?? as ??', [`${sourceAlias}.${fieldName}`, `${tableAlias}__${fieldName}`]);
    });