It's just a draft, I will complete the description later

Use case
If some table depends on another table or dictionary (for example, expression in MATERIALIZED, ALIAS or DEFAULT contains joinGet(...) or dictGet(...) or IN operator with StorageSet, maybe there are some other scenarios), then clickhouse-server may fail to start because it doesn't take into account such dependencies.

Describe the solution you'd like
See #15157 (comment)

Additional context
It would be great to collect all related issues here to choose the proper solution.
#8004 #13613 #13059 #15157 #13359