Option to use labels as names for sql select fields

[sgunnzero]

Have just started using RedQueryBuilder, quite impressed. The form I'm using it in returns a table of results. I'd really like the column names to be the labels supplied, rather than the database field names. This could be accomplished by adding an AS clause to the select fields - e.g.

SELECT x0.db_column_name AS MyLabel

I'm going to manually add them to the sql in onSqlChange, but it would be nice if it was automated.

Thanks, Stuart

[salk31]

Hello,

Are you using the JS version? For better or worse it is sort of hardwired in there.

At some point I'd like to support self joins, would you have any preference on what labels might be used then?

[sgunnzero]

Hi,

Yes, the JS version. No opinion on self joins. I ended up storing the sql twice - one in a basic form that redquerybuilder could load, and one in a converted form including AS fields and some extra joins.

Thanks, Stuart

[salk31]

OK. I think I'll cast this as a feature request to have proper control over the "SELECT" part of the query, generally RQB doesn't do much in this area. Is for the developer.

Please scream if that is an abuse of this ticket.