© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•3y ago•
4 replies
CrisOG

sql.placeholder not working for pg array of strings

const create = db
  .insert(eventTable)
  .values({
    title: sql.placeholder('title'),
    images: sql.placeholder('images')
  })
  .returning()
  .prepare('createEvent');
const create = db
  .insert(eventTable)
  .values({
    title: sql.placeholder('title'),
    images: sql.placeholder('images')
  })
  .returning()
  .prepare('createEvent');

export const eventTable = pgTable('event', {
  id: uuid('id').primaryKey().defaultRandom(),
  title: text('title').notNull(),
  images: text('images').array(),
  createdAt: timestamp('createdAt').notNull().defaultNow(),
  updatedAt: timestamp('updatedAt').notNull().defaultNow()
});
export const eventTable = pgTable('event', {
  id: uuid('id').primaryKey().defaultRandom(),
  title: text('title').notNull(),
  images: text('images').array(),
  createdAt: timestamp('createdAt').notNull().defaultNow(),
  updatedAt: timestamp('updatedAt').notNull().defaultNow()
});


This fails at start time (not even until calling the DB, right after starting the server) with the following error:
TypeError: value.map is not a function
    at PgArray.mapToDriverValue (file:///project/node_modules/drizzle-orm/pg-core/columns/common.js:93:21)
    at file:///project/node_modules/drizzle-orm/sql/sql.js:119:73
    at Array.map (<anonymous>)
    at SQL.buildQueryFromSourceParams (file:///project/node_modules/drizzle-orm/sql/sql.js:72:32)
    at file:///project/node_modules/drizzle-orm/sql/sql.js:91:21
    at Array.map (<anonymous>)
    at SQL.buildQueryFromSourceParams (file:///project/node_modules/drizzle-orm/sql/sql.js:72:32)
    at file:///project/node_modules/drizzle-orm/sql/sql.js:94:21
    at Array.map (<anonymous>)
    at SQL.buildQueryFromSourceParams (file:///project/node_modules/drizzle-orm/sql/sql.js:72:32)
    at file:///project/node_modules/drizzle-orm/sql/sql.js:52:26
    at Object.startActiveSpan (file:///project/node_modules/drizzle-orm/tracing.js:8:14)
    at SQL.toQuery (file:///project/node_modules/drizzle-orm/sql/sql.js:51:19)
    at PgDialect.sqlToQuery (file:///project/node_modules/drizzle-orm/pg-core/dialect.js:362:17)
    at file:///project/node_modules/drizzle-orm/pg-core/query-builders/insert.js:124:53
    at Object.startActiveSpan (file:///project/node_modules/drizzle-orm/tracing.js:8:14)
    at QueryPromise._prepare (file:///project/node_modules/drizzle-orm/pg-core/query-builders/insert.js:123:19)
    at QueryPromise.prepare (file:///project/node_modules/drizzle-orm/pg-core/query-builders/insert.js:128:17)
    at /project/src/server/db/models/event.ts:17:4
    at async instantiateModule (file:///project/node_modules/vite/dist/node/chunks/dep-9A4-l-43.js:50861:9)
TypeError: value.map is not a function
    at PgArray.mapToDriverValue (file:///project/node_modules/drizzle-orm/pg-core/columns/common.js:93:21)
    at file:///project/node_modules/drizzle-orm/sql/sql.js:119:73
    at Array.map (<anonymous>)
    at SQL.buildQueryFromSourceParams (file:///project/node_modules/drizzle-orm/sql/sql.js:72:32)
    at file:///project/node_modules/drizzle-orm/sql/sql.js:91:21
    at Array.map (<anonymous>)
    at SQL.buildQueryFromSourceParams (file:///project/node_modules/drizzle-orm/sql/sql.js:72:32)
    at file:///project/node_modules/drizzle-orm/sql/sql.js:94:21
    at Array.map (<anonymous>)
    at SQL.buildQueryFromSourceParams (file:///project/node_modules/drizzle-orm/sql/sql.js:72:32)
    at file:///project/node_modules/drizzle-orm/sql/sql.js:52:26
    at Object.startActiveSpan (file:///project/node_modules/drizzle-orm/tracing.js:8:14)
    at SQL.toQuery (file:///project/node_modules/drizzle-orm/sql/sql.js:51:19)
    at PgDialect.sqlToQuery (file:///project/node_modules/drizzle-orm/pg-core/dialect.js:362:17)
    at file:///project/node_modules/drizzle-orm/pg-core/query-builders/insert.js:124:53
    at Object.startActiveSpan (file:///project/node_modules/drizzle-orm/tracing.js:8:14)
    at QueryPromise._prepare (file:///project/node_modules/drizzle-orm/pg-core/query-builders/insert.js:123:19)
    at QueryPromise.prepare (file:///project/node_modules/drizzle-orm/pg-core/query-builders/insert.js:128:17)
    at /project/src/server/db/models/event.ts:17:4
    at async instantiateModule (file:///project/node_modules/vite/dist/node/chunks/dep-9A4-l-43.js:50861:9)
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements

Similar Threads

sql operator with array of strings
Drizzle TeamDTDrizzle Team / help
2y ago
sql placeholder with an array throws an error
Drizzle TeamDTDrizzle Team / help
2y ago
array of number returning strings
Drizzle TeamDTDrizzle Team / help
2y ago
COALESCE to json array not working in sql function
Drizzle TeamDTDrizzle Team / help
13mo ago