UPDATE Statements

Basic UPDATE

Update existing records using filter and set:

update User filter id = 1 set {
  name := "Alice Smith"
}

-- Transpiled SQL
UPDATE User SET name = 'Alice Smith' WHERE id = 1

Update Multiple Fields

update User filter id = 1 set {
  name := "Alice Smith",
  email := "alice.smith@example.com",
  updated_at := "2024-01-15"
}

-- Transpiled SQL
UPDATE User
SET name = 'Alice Smith', email = 'alice.smith@example.com', updated_at = '2024-01-15'
WHERE id = 1

Update with Complex Filter

update Product filter category = "Electronics" set {
  on_sale := true
}

-- Transpiled SQL
UPDATE Product SET on_sale = true WHERE category = 'Electronics'

Update All Records

update User set {
  newsletter := false
}

-- Transpiled SQL
UPDATE User SET newsletter = false