The new SQL backend should both be a good example of how to approach SQL generation using the new re-linq front-end (QueryModel, usw.) and provide a sound, extensible architecture backing re-store's LINQ provider.
It will sport SQL generation in three phases:
LINQ providers will be able to hook into each of the three steps for customization, optimization, and advanced query transformations.
Support for queries of the following forms: where kitchen.Cook == otherKitchen.Cook, where kitchen.Cook == outerCook (where outerCook is a constant passed from outside the query).
The SQL generated for such queries performs primary key comparisons.
Support for queries of the form: from s in ... orderby s.ID, s.FirstName orderby s.LastName, s.MiddleName select s.
This generates a single SQL ORDER BY clause; the conditions are appended to each other, so that later LINQ orderby clauses have higher ordering priority (ORDER BY s.LastName, s.MiddleName, s.ID, s.FirstName).