[FEATURE]: Update is_in_list and is_not_null_and_is_in_list functions to optionally handle case sensitivity

[VikYadav]

Is there an existing issue for this?

• I have searched the existing issues

Problem statement

Currently, the is_in_list and is_not_null_and_is_in_list functions perform a case-sensitive check, which may cause valid rows to fail when their values exist in the allow list but differ in letter case (e.g., uppercase vs. lowercase).

Proposed Solution

When case sensitivity is disabled, ensure that both the column value and the allow list values are converted to a consistent case (either lowercase or uppercase) prior to performing the comparison.

Additional Context

No response

[AdityaMandiwal]

Hi @VikYadav, I am willing to work on this.