Currently we require lambda expressions used in higher-order SQL functions (e.g., array manipulation) to be pure functions. Calcite recently added support for lambdas that refer to columns that are available in the environment. We should also enable this capability, which will make lambdas significantly more powerful.

This depends on #6642