adamc@372: table t1 : {A : int, B : string, C : float}
adamc@372: 
adamc@372: val q1 = (SELECT *
adamc@372:           FROM t1
adamc@372:           WHERE A = 0)
adamc@373: 
adamc@373: val a1 = (INSERT INTO t1
adamc@373:           VALUES (0, "1", 2.0))
adamc@373: 
adamc@373: val a2 = (UPDATE t1
adamc@373:           SET A = 3, B = "4", C = 5.0)
adamc@373:          
adamc@373: val a3 = (DELETE FROM t1
adamc@373:           WHERE B <> "good")