submodel.raku

model User {
   has Int $.id   is serial;
   has Str $.name is column;
   has Str $.role is column;
}

red-defaults "SQLite";

schema(User).drop;
User.^create-table;

for <user admin root> -> $role { User.^create(:name("user " ~ ++$), :$role) }

submodel Admin of User where *.role eq "admin";

say User.new(:a<admin>) ~~ User;
Admin.^create: :name("new admin");
.say for Admin.^all;