asavinov

    FROM Table AS t WHERE t.Condition SELECT t.col1, t.col2, ...

    SELECT t.col1, t.col2, ... FROM Table AS t WHERE t.Condition

    Loop -> SELECT-FROM-WHERE
    Table -> Collection
    AS t -> Loop instance variable
    WHERE -> condition on instances

    foreach x in Collection
        if x.field == value:
            continue
        // Do something with x, for example, return in a result set

    for x in Collection:

    [(x.col1, x.col2) for x in Collection if x.field2 == value]