pip install pony python from pony.orm import * db = Database() class User(db.Entity): name = Required(str) age = Required(int) email = Optional(str) python db.bind(provider='sqlite', filename='database.sqlite', create_db=True) db.generate_mapping(create_tables=True) python with db_session: user = User(name='John', age=30) python with db_session: users = select(user for user in User if user.age > 25) for user in users: print(user.name) python from pony.orm import * db = Database() class User(db.Entity): name = Required(str) age = Required(int) email = Optional(str) db.bind(provider='sqlite', filename='database.sqlite', create_db=True) db.generate_mapping(create_tables=True) with db_session: user = User(name='John', age=30) with db_session: users = select(user for user in User if user.age > 25) for user in users: print(user.name)