Method select

packages/sql/src/query/QueryBuilder.ts:773–806

(
    fields: unknown,
    distinct = false,
  )

    CTEs
  >;
  select(
    fields: unknown,
    distinct = false,
  ): SelectQueryBuilder<Entity, RootAlias, Hint, Context, RawAliases, any, CTEs> {
    this.ensureNotFinalized();
    this.#state.fields = Utils.asArray(fields as Field<Entity, RootAlias, Context>[]).flatMap(f => {
      if (typeof f !== 'string') {
        // Normalize sql.ref('prop') and sql.ref('prop').as('alias') to string form
        if (isRaw(f) && f.sql === '??' && f.params.length === 1) {
          return this.resolveNestedPath(String(f.params[0]));
        }

        if (isRaw(f) && f.sql === '?? as ??' && f.params.length === 2) {
          return `${this.resolveNestedPath(String(f.params[0]))} as ${String(f.params[1])}`;
        }

        return f;
      }

      const asMatch = FIELD_ALIAS_RE.exec(f);

      if (asMatch) {
        return `${this.resolveNestedPath(asMatch[1].trim())} as ${asMatch[2]}`;
      }

      return this.resolveNestedPath(f);
    }) as any;

    if (distinct) {
      this.#state.flags.add(QueryFlag.DISTINCT);
    }

    return this.init(QueryType.SELECT) as any;
  }

  /**
   * Adds fields to an existing SELECT query.