[SPARK-37940][SQL]upgrade to new error class in QueryCompilationErrors.

[yuexing]

What changes were proposed in this pull request?

As stated in https://issues.apache.org/jira/browse/SPARK-37940, migrate the following errors to new error mechanism:

1. unexpectedRequiredParameter→UNEXPECTED_REQUIRED_PARAMETER
2. missingStaticPartitionColumn→MISSING_STATIC_PARTITION_COLUMN
3. dataTypeOperationUnsupportedError→DATATYPE_OPERATION_UNSUPPORTED
4. callDeprecatedMethodError→DEPRECATED_METHOD_CALL
5. mustOverrideOneMethodError→MUST_OVERRIDE_METHOD

Why are the changes needed?

see https://issues.apache.org/jira/browse/SPARK-37935

Does this PR introduce any user-facing change?

No

How was this patch tested?

UT

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

No