> Because this storage system’s query language is more powerful than the underlying one’s, its read operations in general may overfetch and then filter results.

Seems like this is the crux of the problem. Migrating and/or replicating data to an underlying data layer that supports the required query logic probably makes more sense?