Cannot perform searches that only contain "NOT"s

[JackBister]

For example you cannot search for source!=*access*.

This seems to be a limitation in SQLite FTS, when running this query:

SELECT
	e.id,
	e.host,
	e.source,
	e.timestamp,
	r.raw
FROM
	Events e
INNER JOIN EventRaws r ON
	r.rowid = e.id
WHERE
	e.id < 748246
	AND e.timestamp >= '2021-01-09 18:10:59.6623322 +0100 CET m=-886.364488199'
	AND EventRaws MATCH 'NOT source:*access* '
ORDER BY
	e.timestamp DESC,
	e.id DESC;

directly against the database I get the following error: malformed MATCH expression: [NOT source:*access* ]

I'm sure there's a way to work around it.