public Tree</*WYSE*/IReadOnlyListDictionary> GetReportColumns(TraceTree parentTraceTree)
{
    var traceTree = parentTraceTree.AddChild();
    traceTree.RecordCodeMethodExecution(MethodBase.GetCurrentMethod());

    // It is good practice to decouple internal ids from externally used ones.
    // WYSE provides the means to do so.
    // However, for a better, easier to follow demo the ids are kept the same here.
    var customerTable = DemoTemplateAliasing.CreateAliasTemplate<CustomerTable>("Customer");
    
    var genericMappings = _genericMappingsRepository.All
        /*WYSE*/.DownstreamOf<CustomerTable>();

    var selectBuilder = new /*WYSE*/SelectBuilder<CustomerTable, Customer>(
        customerTable,
        genericMappings);

    var select = selectBuilder.Build();

    // Default implementation of the interface that only switches from the '.'
    // in external ids and the '_' in an expression's alias
    var aliasTranslator = new /*WYSE*/AliasTranslator();
    
    return select./*WYSE*/GetListDictionaryTree(aliasTranslator);
}

// Generate a report with all columns and no where clause.
public IReadOnlyList<Customer> GenerateFullReport(TraceTree parentTraceTree)
{
    var traceTree = parentTraceTree.AddChild();
    traceTree.RecordCodeMethodExecution(MethodBase.GetCurrentMethod());

    var customerTable = DemoTemplateAliasing.CreateAliasTemplate<CustomerTable>("Customer");
    
    var genericMappings = _genericMappingsRepository.All
        /*WYSE*/.DownstreamOf<CustomerTable>();

    var selectBuilder = new /*WYSE*/SelectBuilder<CustomerTable, Customer>(
        customerTable,
        genericMappings);
    // Alternatively...
    //var selectBuilder = new /*WYSE*/SelectBuilder(customerTable, typeof(Customer), genericMappings);

    var select = selectBuilder.Build();

    return _sqlExecuter.GetItemTrees<CustomerTable, Customer>(
        select,
        customerTable,
        genericMappings,
        parentTraceTree);
}

public IReadOnlyList<TItem> GetItemTrees<TList, TItem>(
    /*WYSE*/ISelect select,
    TList primaryList,
    IReadOnlyList</*WYSE*/GenericMapping> genericMappings,
    TraceTree parentTraceTree)
    where TList : /*WYSE*/IDbDataReaderConvertableList<TItem>
    where TItem : /*WYSE*/IKeyEquatable
{
    var traceTree = parentTraceTree.AddChild();
    traceTree.RecordCodeMethodExecution(MethodBase.GetCurrentMethod());

    using SqlConnection connection = _connectionFactory.Create();
    connection.Open();

    using SqlCommand command = connection.CreateCommand()
        // A WYSE Render context determines certain (overridable) render settings.
        // Here the context is SqlServer. More SQL flavors are supported.
        // A WYSE render builder is used for stringifying
        // the strongly typed SQL statements.
        /*WYSE*/.For(select,
            _renderContextFactory.Create(new DefaultQueryExecutionSettings()),
            _createRenderBuilder);

    try
    {
        using DbDataReader reader = command.ExecuteReader();

        var items = reader.GetItemTrees<TList, TItem>(select, primaryList, genericMappings)
            .ToList();

        traceTree.RecordDbCommandExecutionSuccess(
            command.CommandText,
            command.Parameters.ToDictionary(),
            items);

        return items;
    }
    catch (Exception exception)
    {
        traceTree.RecordDbCommandExecutionFailure(
            command.CommandText,
            command.Parameters.ToDictionary(),
            exception);

        return default;
    }
}

SELECT
    [Customer].[Id] [Customer_Id],
    [Customer].[FirstName] [Customer_FirstName],
    [Customer].[LastName] [Customer_LastName],
    [Customer].[DateOfBirth] [Customer_DateOfBirth],
    [Customer].[IsPreferred] [Customer_IsPreferred],
    [Customer].[HomeAddressId] [Customer_HomeAddressId],
    [Customer].[BillingAddressId] [Customer_BillingAddressId],
    [CustomerHomeAddress].[Id] [CustomerHomeAddress_Id],
    [CustomerHomeAddress].[City] [CustomerHomeAddress_City],
    [CustomerHomeAddress].[ZipCode] [CustomerHomeAddress_ZipCode],
    [CustomerHomeAddress].[Street] [CustomerHomeAddress_Street],
    [CustomerHomeAddress].[HouseNumber] [CustomerHomeAddress_HouseNumber],
    [CustomerHomeAddress].[HouseNumberAddition] [CustomerHomeAddress_HouseNumberAddition],
    [CustomerBillingAddress].[Id] [CustomerBillingAddress_Id],
    [CustomerBillingAddress].[City] [CustomerBillingAddress_City],
    [CustomerBillingAddress].[ZipCode] [CustomerBillingAddress_ZipCode],
    [CustomerBillingAddress].[Street] [CustomerBillingAddress_Street],
    [CustomerBillingAddress].[HouseNumber] [CustomerBillingAddress_HouseNumber],
    [CustomerBillingAddress].[HouseNumberAddition] [CustomerBillingAddress_HouseNumberAddition],
    [Purchase].[Id] [Purchase_Id],
    [Purchase].[CustomerId] [Purchase_CustomerId],
    [Purchase].[ProductId] [Purchase_ProductId],
    [Purchase].[Quantity] [Purchase_Quantity],
    [Purchase].[Date] [Purchase_Date],
    [Purchase].[DeliveryAddressId] [Purchase_DeliveryAddressId],
    [PurchasedProduct]._8789fcda8b58437ca2c0c0320188d0a0 [PurchasedProduct_Id],
    [PurchasedProduct]._102281df06b5484584d8766a288cdc23 [PurchasedProduct_Name],
    [PurchasedProduct]._8ceb40b4f2174b55b90fb5562e97f721 _06584432c64c9dad5012525c8f3edfd1,
    [PurchasedProduct]._0f2cea89a65347d18a2b8cf92684761b _b380dc7a894b56c6b5399a93753a69b8,
    [PurchasedProduct]._1a1240e2df84437faa50feb4e9a58767 [PurchasedProduct_Price],
    [PurchaseDeliveryAddress].[Id] [PurchaseDeliveryAddress_Id],
    [PurchaseDeliveryAddress].[City] [PurchaseDeliveryAddress_City],
    [PurchaseDeliveryAddress].[ZipCode] [PurchaseDeliveryAddress_ZipCode],
    [PurchaseDeliveryAddress].[Street] [PurchaseDeliveryAddress_Street],
    [PurchaseDeliveryAddress].[HouseNumber] [PurchaseDeliveryAddress_HouseNumber],
    [PurchaseDeliveryAddress].[HouseNumberAddition] [PurchaseDeliveryAddress_HouseNumberAddition]
FROM [Customer] [Customer]
LEFT JOIN [Address] [CustomerHomeAddress] ON ([Customer].[HomeAddressId] = [CustomerHomeAddress].[Id])
LEFT JOIN [Address] [CustomerBillingAddress] ON ([Customer].[BillingAddressId] = [CustomerBillingAddress].[Id])
LEFT JOIN [Purchase] [Purchase] ON ([Customer].[Id] = [Purchase].[CustomerId])
LEFT JOIN
(
    SELECT
        _667b8fb98bd345ce932618e1213dc9b2.[Id] _8789fcda8b58437ca2c0c0320188d0a0,
        _667b8fb98bd345ce932618e1213dc9b2.[Name] _102281df06b5484584d8766a288cdc23,
        _0c358c55d20b4e37b1d1214fa0393780.[From] _8ceb40b4f2174b55b90fb5562e97f721,
        ISNULL(_0c358c55d20b4e37b1d1214fa0393780.[UpTo], '3000-01-01 00:00:00.000') _0f2cea89a65347d18a2b8cf92684761b,
        _0c358c55d20b4e37b1d1214fa0393780.[Price] _1a1240e2df84437faa50feb4e9a58767
    FROM [Product] _667b8fb98bd345ce932618e1213dc9b2
    INNER JOIN [ProductPriceHistory] _0c358c55d20b4e37b1d1214fa0393780 ON (_667b8fb98bd345ce932618e1213dc9b2.[Id] = _0c358c55d20b4e37b1d1214fa0393780.[ProductId])
) [PurchasedProduct] ON
(
    ([Purchase].[ProductId] = [PurchasedProduct]._8789fcda8b58437ca2c0c0320188d0a0)
    AND
    ([PurchasedProduct]._8ceb40b4f2174b55b90fb5562e97f721 <= [Purchase].[Date])
    AND
    ([PurchasedProduct]._0f2cea89a65347d18a2b8cf92684761b > [Purchase].[Date])
)
LEFT JOIN [Address] [PurchaseDeliveryAddress] ON ([Purchase].[DeliveryAddressId] = [PurchaseDeliveryAddress].[Id])