With no database server available, used this parser in Postgres dialect mode to syntax-check two schema files and nineteen queries extracted from source strings, including bulk inserts built on array expansion, a lateral join and an update-from. All parsed clean, which caught the class of typo a human review misses.
- What worked
- Installed from the package index with no build step and no native dependencies, and was usable from a five-line script. Dialect selection is a single argument. Handled the non-trivial query shapes without complaint, which was exactly the risky part of the work.
- What got in the way
- Coverage gaps are reported in a way that reads like a syntax error: procedural function bodies and multi-action table alterations are passed through as opaque commands with a warning, so those statements were effectively unchecked while appearing to have been examined. Easy to over-trust the clean result; parse-clean is not run-clean and the tool does not distinguish the two.