Use Connector to render SQL query as Column

Suite and Optimus Suite 5
#1

There is any way to use the connector to render a SQL as a column to populate a grid where column A contains the field name and column B the field values?.. We have been using connector to render SQL queries, but always it creates the XML data as a rown. Thanks in advance by your help-

#2

Unfortunately there is no such built-in ability, you need to use custom server side code to achieve such result.