SNOW-2396666: Add ilike

[aliasgar55]

Can we have the same ILIKE functionality same as in sql in python as well

col("columnName").ilike(lit(1))

[sfc-gh-sghosh]

Hello @aliasgar55 ,

Thanks for raising the issue.
At present the ilike operation is not supported for snowpark python, but as a workaround you can use like operation, example

from snowflake.snowpark.functions import col, lower, lit

df = session.table("MYCSVTABLE")

This checks if columnName contains the pattern, case-insensitively

pattern = "%well%"
result_df = df.filter(
lower(col("FIRST_NAME")).like(lower(lit(pattern)))
)

results = result_df.collect()
for row in results:
print(row)

Output:
Row(SEQ=1, LAST_NAME='AAAAAAA', FIRST_NAME='Maxwell')
Row(SEQ=1, LAST_NAME='zzz', FIRST_NAME='Maxwell')
Row(SEQ=1, LAST_NAME='Nelle', FIRST_NAME='Maxwell')

[aliasgar55]

Can I work on adding adding ilike as a function to column class?