[Feat]: Enum to ORDER BY CASE statement

[GeekMasher]

What new feature are you looking for / expect?

To get better support for enums we should all support for when .order("column", Order::Asc) is used we generate a CASE

enum UserState {
    Active,
    Inactive,
    Banned,
}

This turns into:

ORDER BY 
  CASE ID
    WHEN 'Active' THEN 0
    WHEN 'Inactive' THEN 1
    WHEN 'Banned' THEN 2
  END

Sources

• https://stackoverflow.com/questions/3303851/sqlite-and-custom-order-by

Expectations

Nice to have