I'm excited to introduce Naked SQLAlchemy, a thin wrapper over SQLAlchemy Core that simplifies database interactions in Python. After facing pitfalls with traditional ORMs—like in-memory data not matching the actual database state due to complexities like identity mapping and dirty tracking—I realized these features, meant to ease development, often make things more complicated and harder to learn. Naked SQLAlchemy bridges over these unnecessary layers by promoting explicit SQL usage and direct mapping of query results to Python dataclasses.

Besides significant speed improvements (nearly twice as fast as traditional ORMs), Naked SQLAlchemy is easy to learn because it builds on knowledge you probably already have. It offers automatic dataclass mapping, stateless session management, and treats database views just like tables. By focusing on essential features and bypassing overcomplicated abstractions, it empowers developers to write clear, maintainable code without the usual ORM headaches.

My philosophy is that less is more. By shedding unnecessary layers of traditional ORMs, Naked SQLAlchemy provides a reliable, efficient, and straightforward approach to database access in Python. If you're looking for a tool that sidesteps common ORM pitfalls and leverages your existing SQL expertise, I invite you to explore Naked SQLAlchemy.