Support for FTS and MATCH statements?

Support Developer
1

Does python-sql have (or the possibility to have) functions/classes for statements unique to FTS (in SQLite)? Such as:

SELECT * FROM TableFTS WHERE TableFTS MATCH '...'
2

MATCH is not a SQL standard operator. Indeed there is SIMILAR TO which is a TODO in sql/operators.py. It seems it can be implemented by using REGEXP operator for SQLite and MySQL.

1 Like