# Update using Query Builder

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

```
await dataSource

    .createQueryBuilder()

    .update(User)

    .set({ firstName: "Timber", lastName: "Saw" })

    .where("id = :id", { id: 1 })

    .execute()
```

This is the most efficient way in terms of performance to update entities in your database.

## Raw SQL support[​](#raw-sql-support "Direct link to Raw SQL support")

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

```
await dataSource

    .createQueryBuilder()

    .update(User)

    .set({

        firstName: "Timber",

        lastName: "Saw",

        age: () => "age + 1",

    })

    .where("id = :id", { id: 1 })

    .execute()
```

> Warning: When using raw SQL, ensure that values are properly sanitized to prevent SQL injection.