Unaccented database queries

[iofreddy85]

Problem

With Postgres adapter when having a database with text data in languages with accents and tildes (i.e Portuguese, Spanish, French) is not possible to search for words by ignoring the accent in vowels.
For instance... If a text column has the word 'João' (which is a name in Portuguese language), It'd be nice to be able to search for 'Joao' and get a match of that record.
I've seen this behaviour in other platforms and autocomplete tools in which the search is accent (tilde) insensitive, however when using the autocomplete in the relationship field in payloadcms, this feature doesn't seem to exist.

I see the code in the 'like' operator is as follow:

if (operator === 'like') {
  constraints.push(
    and(
      ...val
        .split(' ')
        .map((word) => adapter.operators.like(table[columnName], `%${word}%`)),
    ),
  )
  break
}

but I don't know if this change is something it should be done in payloadcms code, drizzle, or even a database configuration/plugin.

Does anybody know how we can achieve this behaviour in payload?