I don't think so. You can have unindexed columns on fts tables but I don't think you can directly combine non-fts query filters in that way. You can do it, but

I don't think so. You can have unindexed columns on fts tables but I don't think you can directly combine non-fts query filters in that way. You can do it, but you need to manually filter from the main table then subquery the fts index, or use a join, etc. It's powerful but the interface isn't as friendly as it could be in that way. The sqlite extension system is powerful enough that an extension could unify the behaviors as you describe. It's just not how the fts5 extension interface is exposed, and afaik no one has written an extension on top of it to make it easier to use.