Can't create row with default values

[codepunkt]

It seems impossible to create a new row if a table has only auto-generated columns, e.g. postgres gen_random_uuid() id

model Cart {
  id    String     @id @default(dbgenerated("gen_random_uuid()")) @db.Uuid
  items CartItem[] @relation

  @@map("carts")
}

I tried all variations of this I could think of, including using raw sql, but everything I tried resulted in SQL syntax errors:

db.insertInto('carts').columns([]).returningAll().executeTakeFirstOrThrow()

The query I need to create here is

insert into "carts" default values returning *

Is there a way to do this?

[koskimas]

There's nothing built-in, but this should work https://kyse.link/?p=s&i=1kOLhQ0FgVdND0Dksk5a

[koskimas]

Hmm.. Maybe it'd be worth it to add a defaultValues() method to the insert query builder.

[koskimas]

Added in 0.27.1.

db.insertInto('person')
  .defaultValues()