I have found my experiments with SQLite here https://github.com/daitangio/knowledge

Give it a try, it is very powerful

I wonder if a FDW could do this. Since just replicating the to-be-searched data should have only a few writers it could work well for moderately sized data.