CREATE TABLE Account (id INTEGER PRIMARY KEY, balance INTEGER, email TEXT); INSERT INTO Account VALUES (1, 20, NULL), (2, 10, 'b@example.test'); BEGIN; UPDATE Account SET balance = balance - 5 WHERE id = 1; ROLLBACK; SELECT id FROM Account WHERE email IS NULL; SELECT balance FROM Account WHERE id = 1;