Glossary: Building APIs with FastAPI

select

Also written: where, session.exec, session.get

SQLModel's way to build a query, as in `select(Product).where(Product.price < 60)`. `session.exec(query).all()` runs it, `.first()` gives one row or None, and `session.get` fetches by primary key.