It sounds like we just need to add a config:

     cross_shard_queries = off

What else am I missing?