Add interfaces for input type inference

The design document around TypeInference already mentioned an InputTypesInference that enables the derivation of missing or incomplete input signatures. The Calcite equivalent is called SqlOperandTypeInference.

For FLIP-65, we will need to implement those interfaces as the planner needs infer the DataType s out of logical types that come from the logical query. This is also beneficial to support the NULL literal in the future.