# From:
# https://github.com/web2py/pydal/tree/v20260313.1#usage-and-documentation
from pydal import DAL, Field
db = DAL('sqlite://storage.db')
db.define_table('thing', Field('name'))
db.thing.insert(name='Chair')
query = db.thing.name.startswith('C')
rows = db(query).select()
print(rows[0].name)
assert rows[0].name == "Chair"
db.commit()