Implement tsvector/tsquery search support for texts in Postgres databases

[Alfagun74]

I request the addition of tsvector/tsquery search support to nestjs-paginate. This feature, highlighted in a recent article (source: https://xata.io/blog/postgres-full-text-search-engine), enables fast and reliable full-text searches in Postgres databases. After discovering a related Stack Overflow answer (source: https://stackoverflow.com/a/64450994) that demonstrated its implementation with TypeORM, I believe extending this functionality to nestjs-paginate would greatly benefit us, because ilike is very slow and non fuzzy enough.

• You could make tsvector/tsquery searches optional for people who would rather like to use ILIKE

• I think a condition to run tsvector/tsquery only on postgres and use ILIKE on different databases could be implemented here: https://github.com/ppetzold/nestjs-paginate/blob/403a9fd1e598a9041882053870923c9519fd9840/src/paginate.ts#L247

[ppetzold]

Sounds good to me. Happy to accept PR :)

[Alfagun74]

I understand, Philipp. I'm currently quite busy myself unfortunately. Hopefully, a volunteer will step in and give it a try. Otherwise, I'd still like to keep this open and investigate it when I have some free time. Thanks for the approval though!