SHI HONG CHIN created TEIIDDES-3033: --------------------------------------- Summary: Automatic add columns by using native SQL query Key: TEIIDDES-3033 URL: https://issues.jboss.org/browse/TEIIDDES-3033 Project: Teiid Designer Issue Type: Feature Request Reporter: SHI HONG CHIN Attachments: 01.jpg, 02.jpg, 03.jpg I am still using Teiid Designer version 8.6.1. Due to the need of using native SQL queries, sometimes I manually create a table, procedure, etc in Teiid Designer. !01.jpg|thumbnail! As you can see in the above screenshot, when creating a relational procedure which return a resultset, I have to manually add column to the result set. If I have many columns to be added, this is time consuming. I hope that the developers of Teiid designer add a feature to allow me to use native SQL query to add columns to the procedure resultset. The datatype and length of the column should be set automatically based on SQL query result. For example, I can just input a native SQL query like "SELECT * FROM TABLEA WHERE COL1 = .......", the columns from the query result will be automatically added to the procedure resultset. !02.jpg|thumbnail! Same issue in creating relational table with native query. In teiid designer, if I want to create a relational table which use native query, I have to manually add the columns. So, I hope that the developers of Teiid designer add a feature to allow me to use native SQL query to add columns to the relational table. Let me give you an example of software which allow me to add columns information by using SQL query. Take a look at the Jaspersoft Studio ( http://community.jaspersoft.com/project/jaspersoft-studio ). It is a software which allow us to design report layout to be used by Business Intelligence software developed by TIBCO. !03.jpg|thumbnail! As you can see, in Jaspersoft Studio, I just need to input a SQL query and then click on "Read Fields", the columns information will be automatically added to the report. Developers of Teiid Designer can implement this feature by either one of the following methods: 1. In the "Native Query" tab of both "Create Relational Table" and "Create Relational Procedure" dialogues, add a button to run the query. After running the query, the columns information from the query result will be automatically added to the "COLUMNS" tab or result set of procedure. 2. In the "Columns" tab of "Create Relational Table" dialog and the "Result Set" tab of "Create Relational Procedure", add a button which will display another dialog for us to enter native query which will be run to add column information. -- This message was sent by Atlassian JIRA (v7.2.3#72005)