Allow INSERT ... SELECT FROM

[Ginden]

Feature Description

Allow InsertQueryBuilder to use SELECT.

The Problem

Following code can't be generated using QueryBuilder

INSERT INTO foo(name)
SELECT "name" FROM other_table

The Solution

Obvious solution would be to use something like:

connection.getRepository(foo)
.insert()
.from(OtherTable, 'other_table')
.innerJoin(YetAnotherTable, 'yet_another_table', 'other_table ... = yet_another_table ...')
.where('...')

Easier to implement would be:

class InsertQueryBuilder<T = any> {
  from(queryBuilder: QueryBuilder<any>, alias?: string, columnNames?: (keyof T)[]);
}

and generate query like

INSERT INTO foo(name)
SELECT alias.name
FROM (
SELECT "name" FROM other_table
) alias

Considered Alternatives

Use other query builder library of construct query manually.

Additional Context

https://www.postgresql.org/docs/14/sql-insert.html

(redacted for clarity)

INSERT INTO table_name [ AS alias ] [ ( column_name [, ...] ) ]
    { query }

Relevant Database Driver(s)

DB Type	Relevant
aurora-data-api	yes
aurora-data-api-pg	yes
better-sqlite3	yes
cockroachdb	yes
cordova	yes
expo	yes
mongodb	yes
mysql	yes
nativescript	yes
oracle	yes
postgres	yes
react-native	yes
sap	yes
sqlite	yes
sqlite-abstract	yes
sqljs	yes
sqlserver	yes

Are you willing to resolve this issue by submitting a Pull Request?

• ✅ Yes, I have the time, and I know how to start.
• ✖️ Yes, I have the time, but I don't know how to start. I would need guidance.
• ✖️ No, I don’t have the time, but I can support (using donations) development.
• ✖️ No, I don’t have the time and I’m okay to wait for the community / maintainers to resolve this issue.

[mortezaPRK]

@Ginden I need this feature and also the one mentioned in #8542.

Do you plan to create a PR for it? if not, I'm ready to it.

[Ginden]

Do you plan to create a PR for it? if not, I'm ready to it.

You will probably be faster, because I will be busy at least until end of September.

[PurpleTape]

Any updates? 🥺🥺🥺

[rohitkhatri]

Any update on this?

[VMolokostovEnergiAI]

Anything so far?

[Ginden]

None, I'm not at company using TypeORM anymore.