v.22.12Improvement

Implement Referential Dependencies for Table Restoration Order from Backup

Implement referential dependencies and use them to create tables in the correct order while restoring from a backup. #43834 (Vitaly Baranov).
Implemented referential dependencies in ClickHouse to ensure tables are created in the correct order when restoring from a backup.

Why it matters

To solve issues related to the restoration of backups where tables with dependencies might be created in the wrong order, causing errors or inconsistencies. This feature automatically manages the creation order based on table dependencies, improving backup restoration reliability and consistency.

How to use it

When restoring from a backup, ClickHouse will now automatically take into account referential dependencies between tables to create them in the correct order. Users do not need to perform any manual steps to enable this; it is integrated into the backup restore process.