This data as json, CSV (advanced)
| Link | rowid ▲ | text1 | text2 | name with . and spaces | content |
|---|---|---|---|---|---|
| 2 | 2 | terry dog | sara weasel | puma | |
| 1 | 1 | barry cat | terry dog | panther |
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "searchable_fts"
USING FTS3 (text1, text2, [name with . and spaces], content="searchable");