UPDATE .. SET

update(BOOK).set(BOOK.TITLE, "New Title")

-- ACCESS, ASE, AURORA_MYSQL, DB2, DERBY, EXASOL, FIREBIRD, H2, HSQLDB, INFORMIX, MARIADB, MEMSQL, MYSQL, ORACLE, 
-- SQLDATAWAREHOUSE, SQLSERVER, SYBASE, TRINO
UPDATE BOOK
SET
  BOOK.TITLE = 'New Title'

-- AURORA_POSTGRES, COCKROACHDB, DUCKDB, POSTGRES, REDSHIFT, SNOWFLAKE, SQLITE, TERADATA, VERTICA, YUGABYTEDB
UPDATE BOOK
SET
  TITLE = 'New Title'

-- BIGQUERY
UPDATE BOOK
SET
  BOOK.TITLE = 'New Title'
WHERE TRUE

-- HANA
UPDATE BOOK
FROM BOOK
SET
  BOOK.TITLE = 'New Title'