Problem
Currently, there is no way to define SQLite triggers directly in .dart database definitions. As far as I know, triggers can only be defined using .drift files.
When defining the database schema purely in Dart, there is no equivalent API for defining triggers. This creates an inconsistency between .drift and .dart schema definitions and forces developers to introduce .drift files even when the rest of the schema is defined in Dart.
Proposal
Introduce a way to define triggers directly in .dart files, similar to how tables, views, and indices can already be defined.
Problem
Currently, there is no way to define SQLite triggers directly in
.dartdatabase definitions. As far as I know, triggers can only be defined using.driftfiles.When defining the database schema purely in Dart, there is no equivalent API for defining triggers. This creates an inconsistency between
.driftand.dartschema definitions and forces developers to introduce.driftfiles even when the rest of the schema is defined in Dart.Proposal
Introduce a way to define triggers directly in
.dartfiles, similar to how tables, views, and indices can already be defined.