Cosmos: Translate non-persisted property in query when possible

[smitpatel]

firstOperator = context.Set<Vehicle>().Select(v => v.Operator).OrderBy(o => o.VehicleName).First();

Here Operator.VehicleName is FK to Vehicle hence not persisted to database. Which fails to translate.

[smitpatel]

Notes:
Non-persisted properties in projection should only materialize. They don't always need to be translated especially the ones where we don't know logic to compute them (user configured value generation).
For the non-persisted properties where we know how to compute values

• Id => would just refer to id key value on server side.
• jObject => materialize only in projection, will fail in other places as there shouldn't be a need to use it directly (yet).
• FK property of nested owned objects - translate it to principal key access as it will be in scope. May not always possible to write this in LINQ if there is no owned to owner navigation so may need some magic in translation.
• Ordinal of owned collection - Failing translation for now. There is no direct function for computation in server and easy to put values by user on client as needed.