So using this tool and building scripts in it just ties users to yet another vendor, right?<p>In that case, if you are already tied to Oracle why not just use their tools rather than something like this? Oracle's tools will <i>hopefully</i> work in lock-step with their releases and there should be no support lag.<p>This looks neat, but why add another layer of lock-in to yet another vendor with the uncertainty that entails?
Most of your favorite languages have sql composition libraries that'll get you 90% of this (Arel for Ruby, SqlAlchemy for Python, etc, etc).<p>The remainder, the "piping" syntax, is pretty easy to implement (Takes about 30-40 lines of ruby on top of Arel, speaking from experience).<p>So then, is this just a matter of wrapping a library in a web page and calling it SAAS? Or am I just totally missing the point?
This might be good for developers, but I'm not sure how it's helpful for either heavy users or beginners. For business analysts, it's just another layer on top of SQL, which slows down processing time, and for beginners, it's now two types of syntax and order they have to learn instead of one.
You can already have a very similar query writing process using the sql WITH clause.<p>on Oracle:<p><a href="http://docs.oracle.com/cd/E11882_01/server.112/e10592/statements_10002.htm#i2129904" rel="nofollow">http://docs.oracle.com/cd/E11882_01/server.112/e10592/statem...</a><p>on SQL Server:
<a href="http://msdn.microsoft.com/en-us/library/ms175972.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms175972.aspx</a>
Why not use (virtual) views?<p><a href="http://en.wikipedia.org/wiki/View_(SQL)" rel="nofollow">http://en.wikipedia.org/wiki/View_(SQL)</a>
IMO, this would be more interesting as an alternative way to write complex queries in an ORM.<p>Currently, all ORMs that I've seen try to mimic the declarative SQL syntax, which doesn't always look pretty.
The more I look at programs that generate SQL, the more I think we should just learn how to write proper SQL.<p>Layers are just hiding things, and when you hide it, bad things happen.