drizzle-team / drizzle-team/drizzle-orm

[BUG]: ilike/like doesn't allow pass sql`` as a first agument

Open
#1,954 0 comments 3 reactions 0 assignees View on GitHub
improvement qb/crud
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### What version of `drizzle-orm` are you using?

0.29.3

### What version of `drizzle-kit` are you using?

0.20.14

### Describe the Bug

```
db.query.UsersTable.findMany({
where: () => ilike(
sql`...`, `%${query}%`
)
with: {
roles: true
}
})
```
This code works and executes well with `@ts-ignore`, but there's the type error:
Argument of type 'SQL' is not assignable to parameter of type 'Column, object, object>'.
Type 'SQL' is missing the following properties from type 'Column, object, object>': table, name, primary, notNull, and 13 more.

### Expected behavior

I assume, this code should have no errors, because it executes and works fine

### Environment & setup

Node.js v20.9.0

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.