can you please try, if SELECT *, (SELECT (SELECT *, ->has->api.* AS api FROM ->collection_to_folder->folder) AS folders FROM ->workspace_to_collection->collection) AS collections FROM workspaces:4yuie4oj7jrrhqvs3m7m; returns the desired structure?
SELECT *, (SELECT (SELECT *, ->has->api.* AS api FROM ->collection_to_folder->folder) AS folders FROM ->workspace_to_collection->collection) AS collections FROM workspaces:4yuie4oj7jrrhqvs3m7m;