@PeterJones ,
It appears that it’s a diagrammer, which should help visually see what’s going on, especially when the SQL statement gets complicated.
dBASE has a different tool, that allows us to click on tables, set sorts…etc that creates a SQL statement, without knowing SQL itself as long as you know what operations you want done on the data, the tool, SQL Builder will write the SQL, albeit it’s a subset for dBASE called LocalSQL.
There’s similar capability in MySQL Workbench, that let’s one diagrammatically visualize and create their entire database’s structures, and visually link and set operations.
SQLinForm’s new feature, is a nice tool for a text editor to have, if one wants to diagnose a complex SQL statement that may not be doing what someone wants it to do, breaking down visually the different steps and dependencies that are being used by the statement at different points. I’d say it looks like it does a good job of documenting the SQL code as well. I guess the one thing I’d ask, is does it stay only with Standard SQL or does it see and interpret variants? (MySQL, PostgreSQL, Oracle, and other popular dialects.)
