Method insertFrom

packages/sql/src/query/QueryBuilder.ts:905–918

* Creates an INSERT ... SELECT query that copies rows from the source query. * * Column resolution (3 tiers): * 1. No explicit select on source, no explicit columns → all cloneable columns derived from entity metadata * 2. Explicit select on source, no explicit columns → columns derived

(
    subQuery: QueryBuilder<any>,
    options?: { columns?: Field<Entity, RootAlias, Context>[] },
  )

   * ```
   */
  insertFrom(
    subQuery: QueryBuilder<any>,
    options?: { columns?: Field<Entity, RootAlias, Context>[] },
  ): InsertQueryBuilder<Entity, RootAlias, Context> {
    this.ensureNotFinalized();
    this.#state.type = QueryType.INSERT;
    this.#state.insertSubQuery = subQuery;

    if (options?.columns) {
      this.#state.insertColumns = Utils.asArray(options.columns as string[]);
    }

    return this as unknown as InsertQueryBuilder<Entity, RootAlias, Context>;
  }

  /**
   * Creates an UPDATE query with the given data.