Parsing SQL in SQLEditor

Good progress is being made again on the Cocoa version of SQLEditor. I have recently rewritten the parsing system to use javacc instead of my own home built parser. This allows for better, simpler and more reliable parsing. Writing my own parser was interesting but wasn’t really the best strategy. This new parser should make its way into the java version of SQLEditor eventually.
A key new feature is that the import system can now report parsing errors to the user. Previously the whole thing just kind of gave up without any indication of what went wrong. BAD!
Now you get a nice little window (actually a panel) that appears and gives a list of errors. The current development version always shows this window but I’m still trying to decide if it is better to show it on every import or just when something goes wrong.
The new parser is also much easier to expand to support new features. The old version required a complicated system to add new tokens, the new one has a standard format and requires only a single line.
The new version should also work reliably on Mac OS X 10.2 or Mac OS X 10.3. Which is a change over the previous version that crashed oddly on 10.3.