Well Weaviate is graphql and it has filtering and hybrid search which is a great feature that pg can’t fully support because it doesn’t have bm25
https://weaviate.io/developers/weaviate/api/graphql/filters
https://weaviate.io/blog/hybrid-search-explained
I have a ChatGPT session where I have asked it to do a hybrid search using filtering, pg fts and vector search. Looks reasonable just need to test it and write it up somewhere.