> For the complete documentation index, see [llms.txt](https://sparklytical.gitbook.io/typeorm/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://sparklytical.gitbook.io/typeorm/query-builder/insert-using-query-builder.md).

# Insert using Query Builder

Insert using Query Builder

You can create `INSERT` queries using `QueryBuilder`. Examples:

```typescript
import {getConnection} from "typeorm";

await getConnection()
    .createQueryBuilder()
    .insert()
    .into(User)
    .values([
        { firstName: "Timber", lastName: "Saw" }, 
        { firstName: "Phantom", lastName: "Lancer" }
     ])
    .execute();
```

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:

```typescript
import {getConnection} from "typeorm";

await getConnection()
    .createQueryBuilder()
    .insert()
    .into(User)
    .values({ 
        firstName: "Timber", 
        lastName: () => "CONCAT('S', 'A', 'W')"
    })
    .execute();
```

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