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?