New FindOperator for 'unaccent' command with Postgresql

[soydev019]

Feature Description

I can't use a QueryBuilder in my case and I have to use FindOperators exclusively. This is in the logic of my code, even if it may surprise some of you.

Nevertheless, I need to be able to add the unaccent command to tell my PostgreSQL database with TypeORM that I don't want to take accents into account on my String properties.

The Solution

The solution to my problem would be to have a new FindOperator dedicated to the "unaccent" command, so as to be able to use this mechanism with traditional typeorm methods such as findAndCount.

property: Unaccent(value)

Considered Alternatives

Alternatively, it would be interesting if the FindOperator ILike could surround my value passed as a parameter to the unaccent command like :

ILike(`unaccent(${value})`)

Additional Context

No response

Relevant Database Driver(s)

• aurora-mysql
• aurora-postgres
• better-sqlite3
• cockroachdb
• cordova
• expo
• mongodb
• mysql
• nativescript
• oracle
• postgres
• react-native
• sap
• spanner
• sqlite
• sqlite-abstract
• sqljs
• sqlserver

Are you willing to resolve this issue by submitting a Pull Request?

Yes, I have the time, but I don't know how to start. I would need guidance.