Feature request: update glob cache to cache `OpenFileInfo`

[dentiny]

Is your feature request related to a problem? Please describe. Duckdb changes interface for Glob from a vector of object path to file information (object stats); we need to update corresponding interface and cache otherwise build would break. https://github.com/duckdb/duckdb/blob/b641478fe45e13dc07ef5ce2de903602d1663eae/src/include/duckdb/common/file_system.hpp#L218-L219

Describe the solution you'd like Update interface and update a few accessor implementation to leverage cache. OpenFileInfo allows the extension to cache more information and benefit more API calls (i.e. get last modification timestamp).

Describe alternatives you've considered N/A

Additional context N/A