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]._38c08b037b7d44059a44e1fbfa7dfece [PurchasedProduct_Id],
    [PurchasedProduct]._31332de2ea1641deacd6deea9927fc83 [PurchasedProduct_Name],
    [PurchasedProduct]._2e9bb6fadec64882a0edb2c538eda9ce _a146861832e2b79fca95c4efed222b48,
    [PurchasedProduct]._dc87f1632e8240069d9a5a731db364b2 _7eeb05367149c3cec691a86b9c63f640,
    [PurchasedProduct]._66acb64444f04e06b5aa67262dec4ea2 [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
        _7135318f90ba4fa3b885b44d004a3d48.[Id] _38c08b037b7d44059a44e1fbfa7dfece,
        _7135318f90ba4fa3b885b44d004a3d48.[Name] _31332de2ea1641deacd6deea9927fc83,
        _7a195ce605bd458181f41463a17213dc.[From] _2e9bb6fadec64882a0edb2c538eda9ce,
        ISNULL(_7a195ce605bd458181f41463a17213dc.[UpTo], '3000-01-01 00:00:00.000') _dc87f1632e8240069d9a5a731db364b2,
        _7a195ce605bd458181f41463a17213dc.[Price] _66acb64444f04e06b5aa67262dec4ea2
    FROM [Product] _7135318f90ba4fa3b885b44d004a3d48
    INNER JOIN [ProductPriceHistory] _7a195ce605bd458181f41463a17213dc ON (_7135318f90ba4fa3b885b44d004a3d48.[Id] = _7a195ce605bd458181f41463a17213dc.[ProductId])
) [PurchasedProduct] ON
(
    ([Purchase].[ProductId] = [PurchasedProduct]._38c08b037b7d44059a44e1fbfa7dfece)
    AND
    ([PurchasedProduct]._2e9bb6fadec64882a0edb2c538eda9ce <= [Purchase].[Date])
    AND
    ([PurchasedProduct]._dc87f1632e8240069d9a5a731db364b2 > [Purchase].[Date])
)
LEFT JOIN [Address] [PurchaseDeliveryAddress] ON ([Purchase].[DeliveryAddressId] = [PurchaseDeliveryAddress].[Id])