SNOW-1518075: Support ilike

[ryanhaarmann]

What is the current behavior?

colB.ilike('%value%') produces lower(colB) LIKE lower('%value%')

What is the desired behavior?

`colB ILIKE '%value%'

How would this improve snowflake-connector-python?

Keeps consistent behavior between SQLA API and snowflake SQL.

References, Other Background

Snowflake SQL reference: https://docs.snowflake.com/en/sql-reference/functions/ilike

SQLA reference:
https://docs.sqlalchemy.org/en/20/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.ilike
https://docs.sqlalchemy.org/en/20/core/sqlelement.html#sqlalchemy.sql.expression.ColumnOperators.ilike

[sfc-gh-dszmolka]

hey; thanks for filing this enhancement request with us !