Parsing Issues

The parser and grammar used in piggly is quite a bit simpler than the real PL/pgSQL grammar and parser. Piggly doesn’t need to maintain a symbol table, validate SQL statements, handle parse errors with useful error messages, or really do much beyond building a simplistic syntax tree that identifies branches and loops.

You may find that piggly can’t parse some of your stored procedures. It will probably take a few releases before it can handle a majority of valid syntaxes. Contributions are welcome — filing issues or forking and fixing is appreciated. The grammar can be found in lib/piggly/parser/grammar.tt