Case-insensitive query to a Remote Schema?

[MantisClone]

• Can I use the _ilike case-insensitive operator with a Remote Schema?
• If not, is there a way to make case-insensitive queries to a Remote Schema?

Details:

• I found the _ilike operator for Postgres and BigQuery
• I tried using _ilike with a Remote Schema in a self-hosted Hasura V2 instance, but it wouldn't accept the syntax: transactions(where: {publicKeys_contains: [{_ilike: $from}]}) {

[robertjdominguez]

Hi, @MantisClone 👋

You can't use _ilike with a Remote Schema since Hasura doesn’t automatically apply database-specific operators to remote APIs. The _ilike operator works with Postgres and BigQuery because Hasura translates it into a SQL ILIKE query, but Remote Schemas don’t go through that same transformation.

For case-insensitive filtering, you’ll have to rely on whatever filtering options the remote API provides.

[MantisClone]

Ah, that's a bummer. Thank you for the prompt response 🙏