Enum types for SQLite schemas

[mnpqraven]

So since SQLite doesn't support enum types, is there a way to (better) safely cast data from prisma to rust ? This is what I'm currently doing with my schema
e.g

model Account
id    String @id @default(cuid())
role  String // supposed to only take User or Admin

enum Role {
  User,
  Admin
}
fn cast_role(role_taken_from_prisma: String) -> Result<Role, CastError> {
  // cast logic and handle errors
}

[Brendonovich]

Yeah that's about as good as it gets, implementing FromStr may be a bit more ergonomic but the same problem still applies.