I have been tinkering around with a little Java application I started for running queries against a PeopleSoft database. I was just curious if there was any interest in such an application. Here is a screenshot of what I have so far:
So far the program connects to SQL Server databases and Apache Databases. It runs queries and loads the data into the JTable at the bottom.
I have a SQL “preprocessor” that evaluates the SQL right before it passes it to the database. Currently, the only thing it does is to pull the semi-colon off of the end. But, I plan to have it resolve meta-sql such as %Table() and %CurrentDateIn, etc.
Also, I would like to build SQL tools in that understand the SQL syntax. I would like tools that automatically generate effective date criteria. Another feature would be nice to have where it would join a table into a SQL statement.