drizzle-team / drizzle-team/drizzle-orm
[BUG]: inArray in prepared statements causes syntax error with Planetscale
Open
docs
docs/improvements
priority
- 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.28.6
### What version of `drizzle-kit` are you using?
0.19.13
### Describe the Bug
When using `inArray` in a prepared statement in Planetscale it throws a syntax error:
```ts
const prepared = await db.select().from(table).where(inArray(table.field, sql.placeholder('fields'))).prepare();
await prepared.execute({ fields: ['SOME_VALUE_IN_ARRAY'] });
```
I get an error like this:
```
syntax error at position 256 near 'SOME_VALUE_IN_ARRAY'
```
### Expected behavior
_No response_
### Environment & setup
_No response_
Contributor guide
Assessment
This issue has not been assessed yet.