Consolidate file path creation to LocationProvider

[jackye1995]

Feature Request / Improvement

from #6772 (comment), also copied here:

We have different places for creating file path names,

• LocationProvider for data files
• TableOperations.metadataFileLocation for manifests and manifest lists
• catalog specific impl for metadata file location (e.g. BaseMetastoreTableOperations.newTableMetadataFilePath)

We should consolidate all the file path creations to LocationProvider if possible. Any thoughts? @rdblue @nastra @RussellSpitzer

This would also help us enforce things like object storage mode to not just data files but also metadata files.

Query engine

None

[youngxinler]

If this PR was added, I think it would be better to declare it to tell users that all added paths should follow POSIX compliant paths? Even though we have normalized it internally.

[github-actions]

This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.

[github-actions]

This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'