I'm going through the official book, currently at the DAL chapter. I'm having confusions over query and set objects.
for e.g. 1. To fetch rows one uses , rows = db(db.mytable.myfield!=None).select() it returns a collection of rows, that is fine. But, what is a 'set' then? Isn't 'rows' itself a set of records? 2. A query object represents a sql 'where' clause like, myquery = (db.mytable.myfield != None) | (db.mytable.myfield > 'A') Can't the same thing be done like, rows = db((db.mytable.myfield!=None) | (db.mytable.myfield >'A')) what is the need of having a query object?