How to select specific fields?

[albertalexandrov]

Hi and thanks for the lib!

Could you say please how to select specific fields?

class BusinessUnit(BaseModel):
    __tablename__ = 'businessunit'

    id = Column(Integer, autoincrement=True, unique=True, primary_key=True, nullable=False)
    code = Column(Text, nullable=False, unique=True)
    name = Column(Text, nullable=False)

Now I'm forced to do like this:

BusinessUnit._session.query(BusinessUnit.code, BusinessUnit.id).all()

[michaelbukachi]

@albertalexandrov What would be the result for this scenario? 1. A Result (tuple) object, a full object with only the select fields loaded.