Arbitrary SQL functions in WHERE clause

[carlpaten]

We're building a table view. Users can sort by one or more columns, and can also filter by column value. For example, the column "done" hosts a checkbox, and the user can choose to show only rows where the "done" checkbox is checked.

We'd like one of the columns to be filterable by fuzzy text search, for example entering "abcde" should match "abcdef" and "acbde". Postgres supports a number of trigram distance operators which can be used to implement this filter as a SQL function.

The question is: Is it possible to use a SQL function in the where clause of a Hasura GraphQL query? This would simplify the implementation of custom filters, and enable us to combine multiple such custom filters as needed. Otherwise we'll probably have to generate our own SQL.