Using alias() for 'select as' in SQLAlchemy
You actually want the label method.
result = dbsession.query(Shares.price, \ func.sum(Shares.quantity).label("Total sold")) \ .filter(Shares.company== 'Google') \ .group_by(Shares.price).all()