Pony (source code) is a Python object-relational mapper (ORM) library (database module source code). Pony can be used to interact and manipulate data in relational databases, including PostgreSQL, SQLite and MySQL.
Why you should give Pony ORM a chance explains some of the benefits of Pony ORM that make it worth trying out.
An intro to Pony ORM shows the basics of how to use the library, such as creating databases and manipulating data.
The Pony ORM author explains on a Stack Overflow answer how Pony ORM works behind the scenes. Worth a read whether or not you're using the ORM just to find out how some of the magic coding works.