Following #81040. Try and implement a more generic way to support partition tracking. This PR introduces a new enum that can be the following:

1. none - no dedicated partition tracking (max seen file is only tracked per bucket)
2. hive - this is for the new key=value pairs for hive which maintains max seen filename per bucket and per key=value pair.
3. regex - this is being added in this PR so that the user can specify a flexible partition key from filename.

Specify partition_regex which is a named re2 regex expression and partition_component which specifies which component in the capture group should be used for partitioning. An example as follows:

• filename: server-1_20251217T100000.000000Z_0001.csv
• partition_regex: r'(?P<hostname>[^_]+)_(?P<timestamp>\d{8}T\d{6}\.\d{6}Z)_(?P<sequence>\d+)'
• partition_component: hostname

In the above example, the partitioning per bucket will be done on hostname.

Changelog category (leave one):

• Improvement

Changelog entry (a user-readable short description of the changes that goes into CHANGELOG.md):

Support more generic partitioning for S3Queue ordered mode.

Documentation entry for user-facing changes

• Documentation is written (mandatory for new features)