web2py: DAL dict with specific fields including id

w2p_dal_get_id.py

>>> # Will only return the two requested fields
>>> db(db.page.name=='delft').select(db.page.name, db.page.title).first()
<Row {'name': 'delft', 'title': 'Delft'}>

>>> # Adding the primary key 'id' will return the requested fields BUT all objects and functions too
>>> db(db.page.name=='delft').select(db.page.id, db.page.name, db.page.title).first()
<Row {'comment': <gluon.dal.Set object at 0x102ca8d50>, 'name': 'delft', 'title': 'Delft', 'update_record': <function <lambda> at 0x102cbc488>, 'page_archive': <gluon.dal.Set object at 0x102ca8c90>, 'document': <gluon.dal.Set object at 0x102cba4d0>, 'id': 3, 'delete_record': <function <lambda> at 0x102cbc578>}>

>>> # Using as_dict() will only return the requested fields
>>> db(db.page.name=='delft').select(db.page.id, db.page.name, db.page.title).first().as_dict()
{'name': 'delft', 'title': 'Delft', 'id': 3}