Is it possible to generate sqlite schema migrations when enums/checks change?

[chrisbenincasa]

I use check constraints to implement db-level "enums" in sqlite. It doesn't seem like adding a value to here triggers drizzle to generate a migration. Am I missing something?

Example schema:

const MediaSourceTypes = ['a', 'b'] as const;

const MediaSource = sqliteTable(
  'media_source',
  {
    uuid: text().primaryKey(),
    accessToken: text().notNull(),
    clientIdentifier: text(),
    index: integer().notNull(),
    name: text().notNull(),
    sendChannelUpdates: integer({ mode: 'boolean' }).default(false),
    sendGuideUpdates: integer({ mode: 'boolean' }).default(false),
    type: text({ enum: MediaSourceTypes }),
    uri: text().notNull(),
  },
  (table) => [
    check(
      'media_source_type_check',
      inArray(table.type, table.type.enumValues).inlineParams(),
    ),
  ],
);

Migrations in sqlite are already tedious - was hoping I could alleviate some of the pain there