Search dialog in Website for advanced search in model

Hey there,

I actually write a site for searching in a database and i’d like to have a textfield for searching with queries like
“name = john OR name = jessica AND last_name = smith”
to search for an item with multiple criteria, I didnt find any suitable gem or idea how to realize this.
The model maybe has >2000 columns with >10000 entries.

Regards
Philip