@Guido-Thelen said:
And no, it isn’t limited to Standard SQL. The Navigator visualizes the result of the formatter, so it works with every dialect the formatter supports (30+, including MySQL, PostgreSQL, Oracle, SQL Server, DB2, Snowflake and more). For now it shows SQL statements and DDL. If you run into a statement it doesn’t break down correctly, I’d be glad to get a sample.
That’s good to know, that it handles the different variants, and although I don’t get to do a lot of difficult/complex SQL, there are many in the dBASE community who do, as they use dBASE as the frontend interface and ADO to connect with the different SQL backends to replace the aging BDE.
I’m sure any of our developers who use the dBASE UDL we made can probably use this as well. I clued them into using CSV Lint and Csv Query plugins for working with manipulating text data before importing it, so this tool will also come in handy. I saw some of their complicated SQL when doing the UDL so I could properly implement color coding, keyword and AutoCompletion features and used their sample SQL statements to test against for color coding and keyword collisions.
You’re right, the problem with Workbench is you need a live connection to the data, so this will be a great non-connect SQL diagnostic tool for them. Thanks for doing it and hopefully I’ll be able to play with it sometime soon, but right now my plate is full elsewhere with RL issues.