Node 24 node:sqlite FTS5 MATCH throws 'fts5: syntax error' on user queries with punctuation

问题

Passing raw error text (brackets, colons, quotes) as an FTS5 MATCH query throws instead of returning results.

报错原文（已脱敏/规范化）

SqliteError: fts5: syntax error near "["

适用环境

Node 24 built-in node:sqlite, FTS5 virtual table (trigram or unicode61 tokenizer)

根因

FTS5 MATCH has its own query syntax; unquoted punctuation is parsed as operators.

修复步骤

1. Tokenize the user text yourself and wrap each term in double quotes, escaping inner quotes: "term".
2. Join with OR (or implicit AND) and cap the number of terms.
3. Wrap the query in try/catch and fall back to LIKE.

如何验证

Queries containing [ERROR] foo: bar (x) return rows without throwing.

试过没用的办法

Escaping with backslashes; using MATCH ? with the raw string.

风险提示

None.