query refactoring tool - WITH modeller
967665Oct 15 2012 — edited Oct 17 2012WITH statement - also known as query refactoring is very powerful tool.
Using WITH I'm able to move transformation processes from ETL tools just to plain SQL.
Sometimes I'm using more then 30 WITH tables, reuse them on different level of transformation, depends on the need. After 2 hours of writing such statement my code is difficult to navigate, map some new column through all transformations, etc.
Are there any tools which are designed to organized work with WITH?
Can be anything, representation of queries as blocks and their column list, connections.
Didn't try ODI, which is ELT tool so it may do what I want, but are there anything cheaper? not exactly ELT/ETL tools, just a modeller.