hi, at the moment the only solution is to mark it as unique and check for not null in application code as you insert.
I know this isn't great, unfortunately not null without a default conflicts somewhat with us applying migrations across branches. We do have a plan to solve that, though.