What is your level of proficiency with the SQLAlchemy library and what tool domain have you worked with it?

SQLAlchemy is a powerful ORM library for Python that allows working with databases at a high level of abstraction, as well as using SQL directly.

The level of proficiency can range from a basic understanding of models and sessions to advanced usage:

• Defining models using the declarative style.
• Creating and managing sessions for database interaction.
• Executing queries using ORM and Core.
• Database schema migrations (e.g., with Alembic).

Example of defining a model and a simple query:

from sqlalchemy import Column, Integer, String, create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()

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

engine = create_engine('sqlite:///example.db')
Session = sessionmaker(bind=engine)
session = Session()

# Get all users
users = session.query(User).all()
for user in users:
    print(user.name)

The tool domain includes web development, data processing scripts, automation, where working with databases is required.