models.py

gistfile1.txt

class User(Base):
    __tablename__ = "users"
    id = Column(Integer, primary_key=True)
    username = Column(String(32))
    # ...

users = Collection(DBSession, User, "username")

root = {"users": users}
# or root = users