It's pretty much db([where clauses]).select() Add .first() or last() when you want one record.
select * from item where id=1
rows = db(db.item.id==1).select().first()
& for compound queries:
rows = db((db.item.id>5)&(db.item.id<10)).select()
