Case sensitive sql query

[arashi-dev]

This is my code:

db
.insert(schema.post)
.values(
  posts.map(({title, publishedAt}) => ({
  title,
  publishedAt,
})))
.onConflictDoUpdate({
  target: schema.post.title,
    set: {
      title: sql`EXCLUDED.title`,
      publishedAt: sql`EXCLUDED.publishedAt`,
    },
});

in the result query, the publishedAt becomes publishedat which throws an error. I also tried these solutions:

// same problem. they become publishedat
sql`EXCLUDED.${post.publishedAt.name}`
sql.raw("EXCLUDED.publishedAt")

// Throws: syntax error at or near "$10"
sql`EXCLUDED.${post.publishedAt}`

Is there any solution for that? other than changing the column names?

[imm]

Hi,

Have you tried this?

sql`EXCLUDED."publishedAt"`

Without quotes, all identifiers are not case sensitive in SQL, as far as I know (at least in postgres).

[arashi-dev]

@imm That worked! Thank you so much!