“For a customer I just finished a larger data lineage project based on approx. 175 SQL files worth of 1 MB of disk space. At my recommentation GSP was used for parsing the SQL files and I didn’t regret it. Starting from zero it took just 3 days to complete the code for analyzing all (partly extremely complex) SQLs and it was pure joy working with GSP.
In my opinion the reasons why GSP excels are:
- It is very cleverly designed
- Its mixture of low-, mid- and high-level accessors to the parse tree satisfy any special need which may arise while making other task stunningly easy to accomplish
- The invention of the Meta-Database interface is a gem among gems
- It covers even the most exotic vendor-specific features (e.g. Oracle’s Multicast)
- It is very mature; one hardly ever finds something one could call a bug
- It comes with a plethora of instructive samples
- It is available for a lot of software platforms and database vendors
- It is extremely cheap
- Gudu Software has a very reasonable trial policy
- Gudu Software provides excellent support — even samples are enhanced upon request, and this even before one licensed the software; new features are added most willingly; help for properly using the API is provided too (most other companies don’t) — and all this is mostly provided within a few days
Congratulations to all designers, implementors and the support staff!”