[EPIC] Fully support ANSI mode

What is the problem the feature request solves?

This epic is to track the work required to fully support ANSI mode in Comet.

Here are some known areas where we need to add ANSI support. This list will grow as we investigate more.

Features that Comet currently implements

• Math
  • Abs https://github.com/apache/datafusion-comet/issues/464
  • UnaryMinus https://github.com/apache/datafusion-comet/issues/465
  • Round/BRound https://github.com/apache/datafusion-comet/issues/466
  • BinaryArithmetic
    • Add https://github.com/apache/datafusion-comet/issues/536
    • Subtract https://github.com/apache/datafusion-comet/issues/535
    • Multiply https://github.com/apache/datafusion-comet/issues/534
    • Divide & IntegralDivide https://github.com/apache/datafusion-comet/issues/533
    • Remainder https://github.com/apache/datafusion-comet/issues/532
• Aggregate expression overflow
  • https://github.com/apache/datafusion-comet/issues/531
• Other
  • Cast (covered in https://github.com/apache/datafusion-comet/issues/286)
  • https://github.com/apache/datafusion-comet/issues/2215

Features that Comet has not implemented yet

• Math
  • Pmod
• Date/time
  • UnixTimestamp
  • ToUnixTimestamp
  • GetTimestamp
  • ToTimestamp
  • DateAdd
  • NextDay
  • MakeDate
  • MakeTimestamp
  • DivideInterval
  • MultiplyInterval
  • MakeInterval

Describe the potential solution

No response

Additional context

No response