Revision history [back]

To retrieve a column from a table in declarative SQLAlchemy 2.0 using bracket notation, you can define the table as a class and then access the column using the getattr() method.

For example, if you have a table named "users" with a column named "id", you can define the table class as follows:

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

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'

    id = Column(Integer, primary_key=True)

To retrieve the "id" column from the "users" table using bracket notation, you can do:

user = User()
id_column = getattr(User, 'id')

Alternatively, you can access the column directly using the class attribute syntax:

id_column = User.id