Comment by tucif

You can already have a very similar query writing process using the sql WITH clause.

on Oracle:

http://docs.oracle.com/cd/E11882_01/server.112/e10592/statem...

on SQL Server: http://msdn.microsoft.com/en-us/library/ms175972.aspx