How to increment a field by 1 when inserting a record?

[riculum]

I'm developing a React application integrating the Drizzle ORM with a PostgreSQL database. In my use case, I need to perform a simultaneous insertion of a new entry into the database and increment a specific column named sku by 1. Additionally, if it's the first entry, I'd like to set the default value of sku to 100000. Is it possible to implement this functionality in a seamless manner? Perhaps through the default operation in the schema?

[Angelelz]

Inserting and updating are two different operations and need to be done in 2 different statements. If this is a block operation where the second step depends on the first, this should be done inside a transaction, to ensure that if any statement fails, all will fail. This is how SQL works.

[riculum]

I have managed to get it up and running

  const [createdArticle] = await db.insert(articles).values(newArticle).returning()
  const [updatedArticle] = await db.update(articles).set({sku: sql`COALESCE((SELECT MAX(sku) + 1 FROM articles), 100000)`}).where(eq(articles.id, createdArticle.id)).returning()

Or do you have any tips on how to optimize this :)