Hi @mattfysh - Thanks for the feedback and providing a detailed use case. It’s not something I’ve heard discussed before, but I do see how it could be useful in that case.
To date I think sync tables have been focused on pulling in stable datasets infrequently. That model isn’t a great fit though for users that want to interactively search through some data, where you would want to optimize for speed over completeness. We had a previous discussion of search paradigms in Packs here:
I’ll pass your feedback on to the team, but unfortunately I wouldn’t expect and product changes here in the short term.