4 replies

prepared statements placeholder typing

Schema

const users = sqliteTable("user", {
  id: text("id").primaryKey(),
  text: text("text"),
})

const users = sqliteTable("user", {
  id: text("id").primaryKey(),
  text: text("text"),
})

const updateUser = db
  .update(users)
  .set({ text: sql.placeholder("text") })
  .where(eq(users.id, sql.placeholder("id")))
  .prepare()

const updateUser = db
  .update(users)
  .set({ text: sql.placeholder("text") })
  .where(eq(users.id, sql.placeholder("id")))
  .prepare()

On the text property I get the following

Type 'Placeholder<"text", any>' is not assignable to type 'string | SQL<unknown> | null | undefined'.

Type 'Placeholder<"text", any>' is not assignable to type 'string | SQL<unknown> | null | undefined'.

The issue only seems to occur in the

set

set

part, is there a reason? A better way?

4 replies

Schema

const users = sqliteTable("user", {
  id: text("id").primaryKey(),
  text: text("text"),
})

const users = sqliteTable("user", {
  id: text("id").primaryKey(),
  text: text("text"),
})

const updateUser = db
  .update(users)
  .set({ text: sql.placeholder("text") })
  .where(eq(users.id, sql.placeholder("id")))
  .prepare()

const updateUser = db
  .update(users)
  .set({ text: sql.placeholder("text") })
  .where(eq(users.id, sql.placeholder("id")))
  .prepare()

On the text property I get the following

Type 'Placeholder<"text", any>' is not assignable to type 'string | SQL<unknown> | null | undefined'.

Type 'Placeholder<"text", any>' is not assignable to type 'string | SQL<unknown> | null | undefined'.

The issue only seems to occur in the

set

set

part, is there a reason? A better way?