Allowed changes to storage_policy to richer options

Why it matters

This feature addresses the limitation where users could not update the storage_policy of a table to another policy offering equal or greater capabilities. It enables more flexible storage policy management, allowing users to optimize storage configurations without downgrading capabilities.

How to use it

Users can change the storage_policy of a table using ALTER TABLE ... MODIFY SETTING storage_policy = 'new_policy', as long as the new policy is not less rich than the existing one.