Let's assume a use case: Drive wants to dispaly the list of documents sorted by modified date using pagination. Ideally page shouuld the list sorted across all the documents user have access to (owned or shared with him).
This seems like a complex probilem to me, as sorting criteria is with the Drive database, and permissons are with SpirceDB.
There might be a middle ground: Dispaly two lists to the user: a) Owned by User b) Shared with User. Even in this case, in orher to figure out the first page for 'Owned by user', Drive has the modified time, SpiceDB has permission. It is still a join problme between two services.
Looking forward for suggestions.