What I struggle with solutions like this is permissions. When having a permission system like row level security in place for sql, how to rewrite all this logic for the search queries?
Right now a Searchbase api key has read access to an entire index or to an “alias”, which is a filtered subset of an index. I agree that row-level security could be really interesting… Could you give an example of your use-case?