def select(self, table, fields=['<STR_LIT:*>'], where=None, orderby=None,<EOL>limit=None, offset=None):
(sql, values) = sqlselect(table, fields, where, orderby, limit, offset)<EOL>self.execute(sql, values)<EOL>return self.fetchall()<EOL>
Query and return list of records.

>>> import getpass
>>> s = DB(dbname='test', user=getpass.getuser(), host='localhost',
... password='')
>>> s.execute('drop table if exists t2')
>>> s.execute('create table t2 (id int, name text)')
>>> s.insert('t2', {'id': 1, 'name': 'Toto'})
>>> rows = s.select('t2')
>>> len(rows)
1
>>> row = rows[0]
>>> row
{'id': 1, 'name': 'Toto'}