Expand FTS' Query Capabilities

[kyrre]

The existing FTS implementation only supports basic term matching. It would be great if we could support more of the advanced query syntax that SQLite's FTS5 offers, enabling more precise searches, e.g.,:

-- Boolean operators
SELECT match_bm25('docs', 'python AND "machine learning"');
SELECT match_bm25('docs', 'python OR java NOT deprecated');

-- Prefix matching  
SELECT match_bm25('docs', 'search* program*');

-- Proximity search
SELECT match_bm25('docs', 'NEAR(machine learning, 5)');

Source: https://www.sqlite.org/fts5.html#fts5_strings

[hpvd]

+1