db.session.query(Test, 'additional').from_statement(
    """
    SELECT test.id AS test_id, test.subject AS test_subject, 99 AS additional
    FROM test
    """
    ).all()
sqlalchemy from_statement dynamic attributes for python objects