Hello. I wonder if Authzed can provide some hints to generate authorized sql queries? I know, I can get from Authzed list of ids of authorized resources, but that list can be too huge in some cases.

scaling ACL filtering (that's how we refer to filtering lists of elements from e.g. a database with a list of authorized resources/subjects from SpiceDB) is a complex problem. We have various options we are looking to support in the short-mid term.

I agree, it's complex problem in general. Is there some advices or guides how to implement to it in some specific use cases with current version of SpiceDB? I'm looking forward to SpiceDB ACL filtering support anyway.

We do have ACL Filtering with

LookupResources

and

LookupSubjects

, it just does not scale well for large datasets, so the proposed long term solution is described in https://github.com/authzed/spicedb/issues/207