Move `DynamicFileCatalog` back to core #27446

Job	Run time
build with wasm-pack	2m 24s
cargo check	3m 36s
cargo test (macos)	5m 3s
Check cargo fmt	33s
cargo test (macos-aarch64)	5m 0s
Verify MSRV (Min Supported Rust Version)	6m 20s
Verify Vendored Code	48s
cargo test (win64)	35m 13s
cargo test (amd64)	10m 6s
cargo test datafusion-cli (amd64)	3m 40s
clippy	5m 14s
cargo test hash collisions (amd64)	9m 45s
cargo doc	3m 39s
cargo test doc (amd64)	12m 56s
cargo examples (amd64)	13m 4s
Run sqllogictest with Postgres runner	3m 17s
cargo test pyarrow (amd64)	2m 40s
verify benchmark results (amd64)	11m 29s
check Cargo.toml formatting	2m 50s
check configs.md is up-to-date	2m 49s
	2h 20m 26s

Provide feedback