search

snowflakedb / snowflake-sqlalchemy

Snowflake SQLAlchemy
https://pypi.python.org/pypi/snowflake-sqlalchemy/
Apache License 2.0
231 stars 151 forks source link

SNOW-1518075: Support ilike #513

Open ryanhaarmann opened 2 months ago

ryanhaarmann commented 2 months ago

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 commented 2 months ago

hey; thanks for filing this enhancement request with us !