Idea here is to treat every Java parameter objects type as SQL ANY type. While disallowing SQL ANY type in result object.
This ticket is specifically to deal with composite types (with nested schema or sub schema) such as generic erasure types
FLINK-9294 covering some of the generic type erasure. The additional changes needed are:
1. Modify FunctionCatalog lookup to use SQL ANY type when a higher level type matching is not viable.
2. Introduce additional FunctionCatalog lookup checks to ensure that additional informations provided by type inference is used for validation purpose.