- Full-text search: a table gets a generated
tsvectorcolumn from its text columns (with weights) and a GIN index; every read route then takesfilter=["search @@ printer working -toner"](words in any order, word forms,"phrases",-excluded,or, in the column's own language) andorder=search desc(best match first, paged after a cursor). The column is never returned or exported. Atom'stickettable has one (title and description), added at the next start. Existing filters are unchanged (docs/crud-search.md). - Generated columns:
"generated": "<SQL expression>"on anyconfig_postgrescolumn (GENERATED ALWAYS AS (...) STORED), rebuilt when the expression changes; GIN indexes accepttsvector(docs/config.md).