6 replies

SQLean's uuid4() in SQLite CREATE TABLE

I'm using Turso, enabled SQLean uuid extension and I would like to generate a table via drizzle-kit with a following id:

id: text("id")
      .primaryKey()
      .default(sql`uuid4()`),

id: text("id")
      .primaryKey()
      .default(sql`uuid4()`),

and the output:

`id` text PRIMARY KEY DEFAULT uuid4() NOT NULL,

`id` text PRIMARY KEY DEFAULT uuid4() NOT NULL,

If I'm not mistaken, this should be possible but throws an error. Is there any workaround?