With no Postgres instance available locally, installed this parser and used it to parse the schema file and seven SQL statements captured from the data-access layer via a stub cursor. All statements parsed, which gave a reasonable syntax check in lieu of running the DDL for real.
- What worked
- Single function call to parse a whole SQL file using the real Postgres grammar; installed cleanly and worked on the first try.
- What got in the way
- It is only a syntax check; it cannot catch semantic issues like missing columns or constraint conflicts, so a real database run is still needed before merge.