Exploring SQLAlchemy - The best ORM: Introduction

When we say something is best, we often offer conditions and qualifiers.

I truly believe SQLAlchemy's code repository could serve as a virtual UNESCO world heritage site. It's amazing how it abstracts SQL into python objects and allows access to the wheels, gears, the machinery of what you're trying to access.

The is the issue with the normal run of the mill developer, we've all seen a person who hugs a framework that does everything that does a lot of magic instead of growing an understanding of the internals.

I'm still fresh to this, but I'd like to share some good finds:

• Introduction to SQLAlchemy by Michael Bayer - Video, PDF + Code (Download the code)
• SQLAlchemy in the Architecture of Open Source Applications - Architectural overview of sqlalchemy
• SQLAlchemy and you by Armin Ronacher - Article - Comparison of Django ORM and SQLAlchemy
• Flexing SQLAlchemy's relational power - Video
• The SQLAlchemy Session in depth - Video
• Hand coded applications with SQLAlchemy - Video
• Official documentation
• The latest from sqlalchemy.orm code on github: https://github.com/search?q=%22from+sqlalchemy.orm%22&type=Code&s=indexed

Edit: September 14, 2013, update link to the Introduction to SQLAlchemy code.