For people interested, you can do FTS in DuckDB without using the official module. I copy-pasted the relevant parts and slightly changed it for my need.

https://github.com/nraynaud/sojourner/blob/main/PDS/db_creat...

Example: https://nraynaud.github.io/sojourner/PDS/explore.html