[SPARK-40008][SQL] Support casting of integrals to ANSI intervals

[amahussein]

Context

• Spark-3.4 Commit: https://github.com/apache/spark/commit/04ea0acf96
• Existing Rapids Issues
  • https://github.com/NVIDIA/spark-rapids/issues/5902
  • https://github.com/NVIDIA/spark-rapids/issues/5120

What changes were proposed in SPARK pull request?

1. to support casting of the integral type: TINYINT, SMALLINT, INT, BIGINT to ANSI interval types.
2. and remove the restriction of casting only single unit intervals.

Why changes were needed?

To conform the SQL standard

Does this PR introduce any user-facing change?

Yes, extends current behavior.

Why it might affect RAPIDS?

Change behavior of casting

Impact on Testing?

Yes, requires new tests cases

Requires Doc update?

No