`ilike` in sqlite

We received an issue on the Astro repo recently about ilike support for our SQLite driver. We decided not to expose ilike as a utility, since we noticed it was incompatible with sqlite on the Drizzle docs: https://orm.drizzle.team/docs/operators#ilike That said, it seems strange that ilike is incompatible but notIlike is. Can someone confirm the documentation badge is correct?
Drizzle ORM - Filters
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
1 Reply
Angelelz
Angelelz4mo ago
ilike is not supported in sqlite, so it should't matter if it's preceded by a not. The Docs are wrong. @Andrew Sherman, can you confirm?
Want results from more Discord servers?
Add your server