• Can SELECT column aliases be controlled during SQL generation; How can custom alias values be specified - Is there an Pentaho Metadata API to customize this?


Expected:
Code:
SELECT isnull(ColName,'Unknown') AS ColumnA
        ,COUNT(*) AS ColumnB
        FROM TableA
        GROUP BY ColName
Actual:
Code:
SELECT 
          isnull(ColumnA, 'Unknown') AS COL0
         ,COUNT(BT_TABLE_A."ACTION") AS COL1
FROM 
          ActualAction BT_TABLE_A
GROUP BY 
          isnull(ColumnA, 'Unknown')