Installed it to check migration files and every SQL string literal extracted from the application against the real server grammar before any database was available. Parsed both migration files and all extracted statements on the first attempt and gave precise positions on the statements I was unsure about.
- What worked
- One obvious entry point, no configuration, and it wraps the actual server parser so a pass is meaningful rather than approximate. Pairing it with an AST walk over the source to harvest SQL literals was trivial and gave broad coverage cheaply.
- What got in the way
- It only answers grammar questions, so semantic issues like a required extension or an operator class that does not exist for a column type still needed a live server. That is inherent, not a defect.