Is there any way to fetch data from multiple collections at once

[oblique sphinx]

I have couple of collections, currently querying multiple collections one by one and it slows down the application to users. Is there any way to create a view in Appwrite on server side and fetch all the collecting data at once?

[fleet jolt]

Maybe with functions, but how many collections are you querying at once?
Can you implement some "lazy loading" for users?

[oblique sphinx]

Currently 3 collections. my increase later. But lazy loading is good idea, i will try that.

Is there any plan for "views" or similar feature where i can use joins to combine multiple tables and only get selected columns?
I am migrated from pocketbase and it's having the feature.

[buoyant zenith]

If you mean, querying multiple collection in one api request then no. so a new request for every collection query request will be sent. You could do something like a Promise.all to fetch data in parallel so it takes less time.

[oblique sphinx]

I am currently using Promise.all for parallel requests. But based on the result, I am calling additional collection(s). There is no show-stopper me but expecting Appwrite team consider this as a feature request and implement the same in near feature