Placeholder for arrays in prepared statement

[ritish78]

Hi, I have prepared statement where we can insert a row in postgres using drizzle/pg-core.

I want to be able to upload multiple url in the same column, so while creating the table I made the table to be of type array of text; imageUrl: text("image_url").array().

In the prepared statement:

1. imageUrl: sql.placeholder("imageUrl") does not work.
2. However having an array directly in prepared statement works: imageUrl: [ "https://placehold.co/600x400", "https://placehold.co/800x800", "https://placehold.co/1200x1000" ]

With the first option, the app does not even compile and throws this error:

node_modules\.pnpm\[email protected]_@[email protected][email protected][email protected]\node_modules\src\pg-core\columns\common.ts:202       
                const a = value.map((v) =>
                  ^
TypeError: value.map is not a function

I searched the issues and saw one open issue with same error but for different use cases. #1927

Can you please help me find how this can be fixed?

Thank you

[ritish78]

Changed to db.insert(userTable).values() instead of the prepared statement, and it still throws the same error.