[Experiment] TypeSafe Query Builder - Allows you to specify a DataSet in the select clause

[mk3008]

    private FluentSelectQuery<order_detail_with_product> SelectOrderDetailWithProduct()
    {
        var od = Sql.DefineDataSet<order_detail>();
        var p = Sql.DefineDataSet<product>();

        var query = Sql.From(() => od)
            .InnerJoin(() => p, () => od.product_id == p.product_id)
            .Select(() => od)
            .Select(() => new { product_name = p.name });
        return query.Compile<order_detail_with_product>();
    }

The above code should generate the following SQL:

select
    od.product_id
    , p.name as product_name
from
    order_detail as od
    inner join product as p on od.prroduct_id = p.product_id