[pycal]

i know relationships don’t typically have props in a store like neo4j, and moreover you can reproduce that in something like postgres with a foreign key

we had a challenge like what you describe though, and were able to avoid new queries by representing the relationships as objects. in so doing, we leverage row level security and jwt claims, which is an approach to authorization which has high epistemical legibility.