in sqlalchemy can or_ look into two columns when more than one word is entered?
===

I have the following command that's kind of working as expected:

    DBSession.query(Users).filter(or_(Users.first_name.contains(search_term),Users.last_name.contains(search_term))).all()

I searches both first and last name in my Users table, so I can find `bob smith` by searching either `bob` or `smith`, but I get no results when I search `bob smith`.  This is obviously because bob is in the first_name column and not `bob smith` so it fails.  But is there a way to do this kind of search within sqlalchemy? 

I know worst I can create a column with the full name but I thought I'd ask just in case it was possible. I'm also tagging this as sql just in case its possible with raw sql then I will just try to igure out the sqlalchemy version based on the raw query.