SQLAlchemy 2.0 Introduction - Create, Insert, Select and Relationships.

SQLAlchemy is an object relational mapper (ORM) for Python that works with databases like SQLite, MySQL and Postgres. But what does it do and how can you perform basic operations like creating a database, tables, insert data, read data and create relationships?