Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 105202

Summary: Convert code into query and convert query into code
Product: [Tools] Data Tools Reporter: Jeff Duska <jeff>
Component: SQLDevToolsAssignee: Project Inbox <dtp.enablement-inbox>
Status: CLOSED WONTFIX QA Contact:
Severity: enhancement    
Priority: P3 CC: bpayton, hui.cao
Version: unspecifiedKeywords: helpwanted
Target Milestone: future   
Hardware: PC   
OS: Windows XP   
Whiteboard:

Description Jeff Duska CLA 2005-07-26 14:39:11 EDT 
I expect that many users of the rdb will be programmers. They will be creating
and testing queries from applications using rdb. It would helpful, if I could
paste in my query string and rdb editor could remove the code stuff. It also be
helpful, if it could turn a query into code. 

For example, 

If I have a query I'm using in Java like 

query ="Select FIRSTNAME, LASTNAME, ADDRESS, CITY, STATE, ZIPCODE from USERS
where FIRSTNAME=?";

It would be cool, if it could extract 

Select FIRSTNAME, LASTNAME, ADDRESS, CITY, STATE, ZIPCODE from USERS where
FIRSTNAME=? 

It would also be nice, if it could generate the query for me. It should be able
to support many lanauages, not just Java
Comment 1 Hui Cao CLA 2006-11-20 09:37:11 EST 
Set target milestone.
Comment 2 Brian Payton CLA 2013-08-01 14:38:10 EDT 
This is out of scope for DTP (given the lack of resources on the project), so I will close this as won't fix.

BTW, there is an IBM product named pureQuery that does this kind of thing.