Is your feature request related to a problem?
Currently. V3 engine Type Coercion depend on ExprCoreType used in V2, and the Type Coerciion logic does not support all TypeChecker.
What solution would you like?
Leverage Calcite RelDataType and TypeCoercionImpl logic.
What alternatives have you considered?
Customize TypeCoercion logic for RexNode.
Do you have any additional context?
n/a