res = session.query(Person).filter(func.concat(Person.first_name, ' ',
    Person.last_name).like('Bob Sm%')).all()
len(res)
res, = res
print(res.first_name, res.last_name)
How to filter concated columns with LIKE using SQLAlchemy?