Creating a Visual SQL Query Constructor
Hi all, this is my first post here, I've read the rules and searched the forums, and did not find an answer yet.
My idea was to build a Visual SQL Query Constructor. Some sort of JavaScript powered webpage. The idea is that a user should be able to build a SQL query by dragging nodes from a toolbox on some sort of workspace. He then would be able to connect these nodes to each other, to form a tree of some sort (having a root, nodes and leaves). If this is a well-formed tree, it even should be an executeable query.
The drag and drop part worked out nicely using JQuery, but I am stuck on the tree part.
I've found toolkits that displayed charts, and even connected graphs (to construct a tree) (draw2d,openJacob). But I didn't find out how I could generate a tree (in XML,JSON,...) from it. Also there aren't many ways of altering a node's content when using draw2d,openJacob. Using a contextmenu to generate some prompts could be an option. Although my idea was to use form elements in these nodes, which could prove to be hard. But perhaps there are other ways.
Does anyone have any ideas on this? I know it's very abstract, and probably not an everyday problem.
Thanks all!