Sqlalchemy is the most popular Python ORM (Object Relational Mapper) and it is highly legit.
What’s an ORM? Well, glad you asked and also glad this guy asked
Sqlalchamy of course is not the only ORM around. There’s a very good chance that you’ll come across this one as well.
Take a little bit of time to learn the fundamentals here: TOPIC: Sqlalchemy Basics
Once you are done with the basics, it’s good to understand migrations. Migrations basically let you version control the structure of your database. This is seriously quite useful if you ever want to actually us an ORM in production (hint: You do!)
TOPIC: Sqlalchemy migrations with Alembic