Hey Guys I'm looking to add a search functionality in my application, I want to basically query a db table and want the query to look through different columns for a match. Is there a way I can do that with the client library?

You can use the or filter for multiple filters for instance ilike. If you want full text search best way is to create a calculated tsvector column from your individual columns and search that. You don’t want to be doing too many text searches on different columns normally for performance reasons.

Can you give me an idea of how the function would look like?

Thanks!