please check the documentations - assets dont hold such dependency relationships!
there is a post here were we discussed implementing tree structures for assets, but is not on the roadmap yet.
The value assets is available in an asset (screenshot from the community version) and does sounds like a relation between assets not?
yes - but is a flat non-hierarchical relationship!
If this relation would be defined/used as a pure parent relationship (parent or parents of this asset) you would be able to get a full hierarchical relationship not? While MySQL doesn’t come with any good native graph queries I think it doesn’t directly request any modifications.