feat: Introduce ansi enable parameter for execution config #18634
Description
Is your feature request related to a problem or challenge?
As was discussed with @Omega359 and @Jefffrey in #15914 (comment) :
A question I have is how do we plan to support spark.sql.ansi.enabled config? I've seen a few PRs for Spark functions that try to cater for this config, but we don't exactly have a way to set this so it usually results in dead code (e.g. a hardcoded boolean that is set to false for now) or their own way of toggling it (e.g. another argument to the function).
ConfigOptions via ScalarFunctionArgs.
This ANSI flag becomes more critical as Spark 4.0 configured the ANSI mode as true by default
https://spark.apache.org/docs/latest/sql-ref-ansi-compliance.html
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response