date_text type used in SQLite not consistently understood by tooling

[berniev]

After fighting this issue for a while, AI helped me write the following:

For SQLite, SeaORM schema sync maps Rust Date to a column type named date_text. SQLite accepts this, but E.G. JetBrains database table editor interprets this type as numeric and rejects ISO date text like 2026-07-01 with “invalid number”.

Since SQLite has no native date type and SeaORM stores dates as text, generated SQLite DDL should preferably use TEXT for Date, or provide a way to override the physical SQLite column type while preserving Rust Date conversion.

create table hooks
(
    id           integer   not null
        primary key,
    period_begin date_text not null,
    period_end   date_text not null
);

And the value that works via SQL but fails in the grid editor:

sql
INSERT INTO hooks (id, period_begin, period_end)
VALUES (1, '2026-01-01', '2026-07-01');