SQLAlchemy 2 In Practice - Chapter 3 - One-To-Many Relationships

Chapter 3 of the SQLAlchemy 2 in Practice book covers implementing one-to-many relationships using SQLAlchemy ORM. It walks through creating a separate Manufacturer model, defining foreign keys, and adding relationship attributes with back_populates. The chapter explains lazy vs. eager loading strategies (select, joined, selectin, subquery, immediate, write_only, etc.) and their performance implications, including the N+1 query problem. It also covers cascade configurations ('save-update, merge' vs. 'all, delete-orphan') for handling deletion and detachment of related objects, with practical code examples throughout.