Linq
Sauce implemented a full IQueryable provider for all supported datastoresJust like the rest of sauce, no code generation is required.
var result = from i in dStore.Query<TestItemForeignKeyWithString>()
join x in dStore.Query<TestItemPrimaryKey>() on i.FKeyField equals x.ID
select new
{
i.ID,
x.Name,
x.Date
};