[SPARK-48229][SQL] Add collation support for inputFile expressions

[uros-db]

What changes were proposed in this pull request?

Introduce collation awareness for inputFile expressions: input_file_name.

Why are the changes needed?

Add collation support for inputFile expressions in Spark.

Does this PR introduce any user-facing change?

Yes, users should now be able to use collated strings within arguments for inputFile functions: input_file_name.

How was this patch tested?

E2e sql tests.

Was this patch authored or co-authored using generative AI tooling?

No.