does anyone know what the best way to list friends would be for a user? I'm migrating from PocketBase where we had a relation from the user table back to the user table, but it doesn't seem like that's possible in Appwrite, unless its a bug?
In PocketBase I just edited my users table, but since I already have an Auth Table AND a user profiles tables, it feels silly to make a third table just to get the same functionality PocketBase gave us in one (hopefull this makes sense haha)