drizzle-team / drizzle-team/drizzle-orm

[BUG]: inArray in prepared statements causes syntax error with Planetscale

Open
#1,415 10 comments 14 reactions 1 assignee Claimed by @Angelelz View on GitHub
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

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.