Get Schema into attribute from SQLExecutor

The python to get a comma separated list of attribute names is fairly straightforward, just send one of the features to a pythoncaller with the code

def processFeature(feature):
    attrNames = ','.join(feature.getAllAttributeNames())
    feature.setAttribute('attrNames', attrNames)

The SchemaSetter will create a list of all attributes.

Why not use the FeatureReader to read both Schema feature and Data features, rather than using the SQLExecutor?

Thanks, I'll try these out, I am using SQL just because it allows me to combine multiple tables together and also use subqueries to deal with a complex data source.

FME_SQL_DELIMITER ;

-drop view $(TEMP_VIEW);

create view $(TEMP_VIEW) as
select a.*, b.value
from table1 as a inner join table2 as b
on b.id = a.id; 

Thanks all, I used the python solution, worked great, the days of typical user having any privs on the database to create stuff are long gone. In case anyone is interested, I am doing this to create a source to target column mapping, I get the column names into the flow, then run therm through an AttributeValueMapper to crosswalk them to the source table.column_name, and query the Oracle All_tab_columns table to get the column comments, so I get a source table name.column_name, target column_name and an attribute definition as a result in an xls, along with the real output in a personal geodatabase