This data as json, CSV (advanced)
| pk ▲ | text1 | text2 | name with . and spaces |
|---|---|---|---|
| 2 | terry dog | sara weasel | puma |
| 1 | barry cat | terry dog | panther |
JSON shape: default, array, newline-delimited
CREATE VIEW searchable_view_configured_by_metadata AS
SELECT * from searchable;