Here's an example from the documentation that just reads like a "rough translation of SQL into Python":

    select((item.order, item.order.total_price,
         sum(item.price * item.quantity))
         for item in OrderItem
         if item.order.total_price < sum(item.price * item.quantity))