Creating a SQL complex query report, with visual design approach, via pipeSQL

Re:Creating a SQL complex query report, with visual design a... by senthadev on Friday November 14, 2014 @05:01PM (#8609768)

pipeSQL author here:

Sorry, I didn't understand your answer. It is very important to understand the complex query in-order to debug or re-engineer. One way is to visualise it as mentioned in the article and convert it to SQL via pipeSQL.

[ Parent | on HN ]

Re:Creating a SQL complex query report, with visual design a... by collyw on Sunday November 16, 2014 @08:32AM (#8614167)

I personally haven't found visual tools made querying any easier, just a new way of doing things - essentially a new syntax. Practising normal SQL and being able to visualize it in my head has been far more use than any visual tools have been to me.

[ Parent | on HN ]