[BUG]: sql placeholder with an array throws an error

[Wisieneu]

What version of drizzle-orm are you using?

0.33.0

What version of drizzle-kit are you using?

No response

Describe the Bug

when executing this code:

const prepQuery = db
  .select()
  .from(table)
  .where(inArray(table.postId, sql.placeholder("postIds")))
  .prepare("prepquery");

const result = await prepQuery.execute({
  postIds: ["esaeasdas", "esaeasdas", "esaeasdas"]
})

Drizzle throws an error: syntax error at or near \"$1\. The code works when I execute the prepared query without the sql.placeholder, hardcoding an argument inside prepQuery - the error is not reproduced anyway else. Do I need to pass the array of strings there differently? I tried converting it into a string, but that does not work neither. It would also be awesome if this case was handled by the ORM, so that no workarounds are needed.

Expected behavior

• array is converted by the prepared query into something acceptable by postgres sql statement
• the documentation describes how to handle more cases in this place: https://orm.drizzle.team/docs/perf-queries#prepared-statement
• i can pass a literal into the sql.placeholder to specify the expected variable type maybe? like:

 sql.placeholder<string[]>("postIds")

Environment & setup

No response

[jonathanpalma]

Is there any current solution to pass arrays as placeholders in prepared statements?

[hyunbinseo]

In SQLite, you cannot pass an array into a placeholder.

In-fact, you need as many ? as the array item count, which can't be done in prepared queries.

A viable workaround is to use json_each — you do have to write a little bit of raw SQL, but it works.

WHERE id IN (SELECT value FROM json_each(?))

Referenced https://ricardoanderegg.com/posts/sqlite-list-array-parameter-query/