Support for ORDER BY CASE WHEN?

[cjfarr]

I have a use case that does not appear to be supported. Please observe this example:

var query = SQLiteConnection.Table<MyClass>()
              .OrderBy(x => x.SomeProperty == "Preferred Value" && x.AnotherProperty == "2nd Preferred")
              .ThenBy(x => x.SomeProperty)
              .ThenBy(x => x.AnotherProperty);

If I were to write this in plain SQL for a tool such as DBeaver it would look like this:

ORDER BY
CASE WHEN 
SomeProperty = 'Preferred Value' AND AnotherProperty = '2nd Preferred'
THEN 0 ELSE 1 
END ASC,
SomeProperty ASC,
AnotherProperty ASC

When I try to run the C# code I get a System.NotSupportedException: 'Order By does not support: [I believe this is the Expression.ToString() from the first OrderBy function in the C# code]. If there is a different way to achieve this sort or have I missed something? Please let me know. Otherwise, could we consider supporting something like this?

Thanks.

[cjfarr]

Adding more info. One of my customers wants a list of work sites ordered by a secondary id then a primary id. However, they want an exception to this sort where the users default work site sits on top.