How can I set attribute to specific columns from SQLAlchemy results?

There are many methods!

Method #1:

You have to get the whole object to update it

Try this:

query = session.query(Table).first()
query.column_one = value # setattr(query, column_one, value)
session.commit()

Method #2:

Using SQLAlchemy Core API

from sqlalchemy import update

stmt = update(Table).where(Table.c.id==5).values(id=1)

More information about this method on this link

There are other methods, mentioned by Ilja Everilä in the comments , So the credit goes to him, upvote his comment!

Method #3:

load_only() method, It can get used like this:

from sqlalchemy.orm import load_only

query = session.query(Table).options(load_only("column_one", "column_two"))
query.column_one = Value
session.commit()

More information about load_only() method on this link

Method #4:

Query.update()

session.query(Table).filter(Table.column_one == 25).update({Table.column_one: 10}, synchronize_session=False)
session.commit()

More information about Query.update() here!