TypeORM Docs

# Insert using Query Builder

You can create INSERT queries using QueryBuilder. Examples:

await dataSource
    .createQueryBuilder()
    .insert()
    .into(User)
    .values([
        { firstName: "Timber", lastName: "Saw" },
        { firstName: "Phantom", lastName: "Lancer" },
    ])
    .execute()
1
2
3
4
5
6
7
8
9

This is the most efficient way in terms of performance to insert rows into your database. You can also perform bulk insertions this way.

# Raw SQL support

In some cases when you need to execute SQL queries you need to use function style value:

await dataSource
    .createQueryBuilder()
    .insert()
    .into(User)
    .values({
        firstName: "Timber",
        lastName: () => "CONCAT('S', 'A', 'W')",
    })
    .execute()
1
2
3
4
5
6
7
8
9

This syntax doesn't escape your values, you need to handle escape on your own.

← Update using Query Builder →