SQL FTS 5

[DPaul]

earching for documentation about this I came across the duckdb database

Thanks, never heard of it either:
https://duckdb.org/2021/01/25/full-text-search.html
Even mariaDB etc... support FTS5.
Unfortunately the decision which DB to use, is not mine.
Some very learned people will meet and tell me tomorrow (hopefully).

As for the documentation, maybe the fact that FTS5 is relatively unknown,
causes the lack of hands-on examples. First you think something is impossible,
the next day you find out there is a way, resulting in loss of time.
I guess that is part of the learning curve.

e.g. what are the consequences of ... using fts5 (filename,data,register, tokenize='trigram') ...?
Should I define every table with " tokenize='trigram'" when I want to use like. Can I convert existing 'normal' tables ... etc etc..;
Paul