panates / sqb / 38260953195

95%

master: 96%

Pull #109

github

feat(sqlite-dialect): serialize Match as an FTS5 full-text search

`Match` fell through to the default `=` in the sqlite dialect. It now
serializes as FTS5 `MATCH`:

- `Match(column, pattern)` -> `column MATCH pattern`, for a query on the
  FTS5 table itself;
- `Match(column, pattern, 'fts_table')` ->
  `rowid IN (SELECT rowid FROM fts_table WHERE column MATCH pattern)`,
  for a table indexed by an external-content FTS5 table;
- `Match(column, pattern, { table, key })` compares the FTS5 rowids with
  `key` instead of `rowid` (aliased tables, INTEGER PRIMARY KEY by name).

Adds `toFtsQuery(text)`, which quotes each word of user input so FTS5
syntax (`^`, `-`, `:`, `*`, `AND`, `NOT`) is searched for rather than
interpreted, like PostgreSQL's `plainto_tsquery`.

Co-Authored-By: Claude Fable 5.1 <noreply@anthropic.com>

2554 of 3055 branches covered (83.6%)

69 of 69 new or added lines in 4 files covered. (100.0%)

19648 of 20886 relevant lines covered (94.07%)

155.13 hits per line