adamc@372: table t1 : {A : int, B : string, C : float}
adamc@372: 
adamc@372: val q1 = (SELECT *
adamc@375:           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@375:          
adamc@373: val a3 = (DELETE FROM t1
adamc@373:           WHERE B <> "good")
adamc@374: 
adamc@374: 
adamc@374: val q2 = (SELECT *
adamc@374:           FROM t1
adamc@374:           WHERE A = 0
adamc@374:             OR B = "hi"
adamc@374:             AND (C <> 10.01
adamc@374:               OR A = 8)
adamc@374:             AND (B = B
adamc@374:               OR B = B
adamc@374:               AND C = C OR (D =
adamc@374:                 6 AND 8 = 8)))