Full text search support out of box

[georgolden]

Is your feature request related to a problem? Please describe.

We need to create a simple way to create full text search indexes and handle search queries within the fields.

Solution

We can start by simple implementation of GIN index.
https://www.postgresql.org/docs/current/textsearch-tables.html#TEXTSEARCH-TABLES-INDEX

To-Do

• clone this repo, run a container or standalone Postgres instance, setup database

git clone [email protected]:metarhia/metasql.git
cd metasql
npm ci
cd db

# optional
sh docker.sh

sh setup.sh
npm t

• implement tests and queries for text-search use cases

This issue is a general, we need to contribute more to this issue as well. @nechaido @tshemsedinov

[georgolden]

https://www.postgresql.org/docs/current/textsearch.html

[tshemsedinov]

@vmkul Please accept invitation to assign for this issue