Issue
My queries on External Objects from within Salesforce are case sensitive, making searches where case sensitivity is undesired difficult. Can I use case insensitive search with Heroku Connect?
Resolution
Unfortunately, there really is no way to do this when using External Objects with Heroku Connect.
Here is an example of how this might be worked around when using OData directly.
The eq operator is intended to results that match case-sensitive strings. In order for a query to be case-insensitive, one can use tolower or toupper in order to normalize the text.
An example:
/opportunities?$filter=tolower(Name) eq tolower('My Opportunity')
This would match Opportunity records with a Name of "My Opportunity", "MY OPPORTUNITY" or "my opportunity".