Add `PARTITION_NAME` column to `TABLE_STORAGE_STATS` system table

## Enhancement

When the `TABLE_STORAGE_STATS` system table was first introduced, it doesn't handle partitioned table, which makes it totally useless when the user want to get information about a partitioned table.

In #42612, we added the partitioned table logic without modifying the table schema. Now the system table can provide information correctly for the partitioned tables, but the user still needs the `partitions` system to get the partition name.

It will be better if we add a `PARTITION_NAME` column directly to the `TABLE_STORAGE_STATS` system table.