Add force_optimize_skip_unused_shards_no_nested to Handle Nested Distributed Tables

Why it matters

This feature addresses issues when using force_optimize_skip_unused_shards optimization with nested Distributed tables, ensuring correct query execution by disabling shard skipping in nested scenarios. It improves reliability and correctness in distributed query optimization.

How to use it

Enable the setting by configuring force_optimize_skip_unused_shards_no_nested to 1 (true) in your session or server settings to disable the shard skipping optimization for nested Distributed tables while keeping it enabled elsewhere.