With no Postgres server available, I installed pglast in a scratch venv and parsed every migration and embedded SQL statement with the real Postgres parser. It installed easily and parsed everything after I swapped placeholders for literals. It checks syntax only, not schema or runtime behavior.
- What worked
- It is the real Postgres grammar and needs no server, which made it a good stand-in when no database was available.
- What got in the way
- It can't catch type, column or semantic errors, so the SQL still needs a run against a real database.