Create SQL queries in Rational Insight

another option is leaving your CQ SQL in the personal queries, define the xdc file against your personal queries and build FM modal against this xdc. the pro is this is easier than doing DM ETL ,the con is every time you sql is changed, you will need to go through the steps again to update xdc and fm model.
the pro of the above solution is you can leverage DB's SQL capability, you will need to learn how to use data manager.

Hi Renato,

The recommended approach for CQ customization using Insight is to modify the ClearQuest XDC file to conform to your CQ schema and customize the ETL and FM model

The only way you could continue to use custom SQL queries against the ClearQuest database is to define a data source in Data Manager that connects directly to the CQ database and add incorporate the datasource/queries in Data Manager to deliver that data to the Insight Data Warehouse.  Or you could create the data source on the report server and incorporate the queries in to your FM model if you are not using ETL/Data Warehouse.  I'd recommend the first approach of using CQ Data Services -> ETL if at all possible.  Hope it helps,