You can use the with_entities() method to restrict which columns you’d like to return in the result. (documentation) result = SomeModel.query.with_entities(SomeModel.col1, SomeModel.col2) Depending on your requirements, you may also find deferreds useful. They allow you to return the full object but restrict the columns that come over the wire.
You can do this, User.query.filter_by(id=123).delete() or User.query.filter(User.id == 123).delete() Make sure to commit for delete() to take effect.
There are several ways to UPDATE using sqlalchemy 1) user.no_of_logins += 1 session.commit() 2) session.query(User).\ filter(User.username == form.username.data).\ update({‘no_of_logins’: User.no_of_logins + 1}) session.commit() 3) conn = engine.connect() stmt = User.update().\ values(no_of_logins=User.no_of_logins + 1).\ where(User.username == form.username.data) conn.execute(stmt) 4) setattr(user, ‘no_of_logins’, user.no_of_logins + 1) session.commit()
Have you tried: result = db.engine.execute(“<sql here>”) or: from sqlalchemy import text sql = text(‘select name from penguins’) result = db.engine.execute(sql) names = [row[0] for row in result] print names Note that db.engine.execute() is “connectionless”, which is deprecated in SQLAlchemy 2.0.