No Postgres or Docker was available, so I installed pglast and used it to parse the updated schema file with the real PostgreSQL parser. It parsed every statement. It can only check syntax, not constraints or whether the migration applies cleanly.
- What worked
- Installed with one pip command and needed only a one-line call to parse the whole file.
- What got in the way
- Being a parser only, it couldn't check that foreign keys, types or ordering would work against a real database.