{"library":"sqlalchemy","install":[{"cmd":"pip install sqlalchemy","imports":["from sqlalchemy import select\nfrom sqlalchemy.orm import Session\n\nwith Session(engine) as session:\n    # v2 style — use select()\n    stmt = select(User).where(User.username == 'alice')\n    user = session.scalars(stmt).first()\n\n    # Insert\n    new_user = User(username='bob', email='bob@example.com')\n    session.add(new_user)\n    session.commit()","from sqlalchemy import String\nfrom sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column\n\nclass Base(DeclarativeBase):\n    pass\n\nclass User(Base):\n    __tablename__ = 'users'\n    id: Mapped[int] = mapped_column(primary_key=True)\n    username: Mapped[str] = mapped_column(String(50), unique=True)\n    email: Mapped[str] = mapped_column(String(120))","from sqlalchemy import create_engine, text\n\nengine = create_engine('postgresql://user:pass@localhost/db')\n\nwith engine.connect() as conn:\n    result = conn.execute(text('SELECT 1'))\n    print(result.fetchall())"]},{"cmd":"pip install 'sqlalchemy[asyncio]'","imports":[]}]}