What did you use to communicate with the database? SQL Alchemy, which version, declarative style?

In Python, the SQLAlchemy library is often used for database communication. It provides ORM (Object-Relational Mapping), allowing interaction with the database through Python objects.

The declarative style is commonly used, where models are described as classes inheriting from Base:

from sqlalchemy import Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)

The version of SQLAlchemy depends on the project, but current versions are 1.4 and 2.0. Version 2.0 introduced new approaches to sessions and asynchronous operations, but the declarative style remains.

If a specific version is needed, it should be clarified in the project or requirements.txt.