Increase the Limit for Querying Nested Relationships

I ran into problem when I upgrade my Appwrite self-hosted from 1.7.4 to 1.8.0. When I query election.position.candidates.votes, it doesn’t return any data. I found out that there's a limitation restricted only to 3 levels https://appwrite.io/docs/products/databases/relationships#limitations. I'm not sure if this changed in 1.8.0, but it was definitely working when I was using 1.7.4.

Did you upgrade your SDK?

I currently use "node-appwrite": "^20.3.0"

That's a 1.8 SDK. 1.8 has changed how relationships work

https://appwrite.io/blog/post/announcing-opt-in-relationship-loading

https://appwrite.io/docs/products/databases/relationships#performance-loading