search

crate / sqlalchemy-cratedb

SQLAlchemy dialect for CrateDB.
https://cratedb.com/docs/sqlalchemy-cratedb/
Apache License 2.0
3 stars 2 forks source link

SQLAlchemy: Investigate if .ilike() should render as ILIKE #98

Closed hlcianfagna closed 1 year ago

hlcianfagna commented 1 year ago

.ilike() is currently rendering as lower() LIKE lower() Using CrateDB's native ILIKE operator could allow to benefit from a more efficient implementation in the backend in the future.

amotl commented 1 year ago

Good idea. The corresponding documentation of SQLAlchemy can be inspected at ^1.

ColumnOperators.ilike():

Case insensitive LIKE makes use of the SQL lower() function on a generic backend. On the PostgreSQL backend it will use ILIKE.

seut commented 1 year ago

Implemented by crate/crate-python#564.