Adds a from clause to the update query.

This is supported only on some databases like PostgreSQL.

The API is the same as {@link QueryCreator.selectFrom}.

Examples

db.updateTable('person')
  .from('pet')
  .set((eb) => ({
    first_name: eb.ref('pet.name')
  }))
  .whereRef('pet.owner_id', '=', 'person.id')

The generated SQL (PostgreSQL):

update "person"
set "first_name" = "pet"."name"
from "pet"
where "pet"."owner_id" = "person"."id"