result = db.session.execute('''select id from passwd 
                                    where id = check_pass(:login,:password)''',
                                {'login': login, 'password': password}).first()

from sqlalchemy import func
db.session.query(User).filter(User.id == func.check_pass(login, password)).first()