Support SQL to Substrait conversion for List functions in Isthmus
Work needed:
- Create a new ListFunctions class (similar to AggregateFunctions) for defining Calcite SQL operators for list/array functions with proper lambda type inference
- The class should define TRANSFORM, FILTER, ANY_MATCH, ALL_MATCH, etc. with:
- Custom SqlReturnTypeInference that infers return types from lambda return types
- Custom SqlOperandTypeChecker that validates lambda parameter types match array element types
- Update SubstraitOperatorTable to use the new ListFunctions definitions
- Add tests for SQL-to-Substrait roundtrip with lambda functions
related work: