I am trying to use the SQL::Statement module (1.33) to parse SQL statements from DB2. I do not need to execute them, just find the involved tables and columns in context. The module does not support some of DB2's peculiarities out of the box even in the few core SQL commands that are supported (such as WITH and FOR clauses used for some optimizations.) The documentation discuss the possibility of adding syntax but is very sparse in explaining how. So here are my questions:

1. It is not clear how to create a file to satisfy

$parser->parse("LOAD 'MyLib::MySyntax' ");

I understand that by sifting through all documentation I should be able to figure it out, but does any of you, by a chance, have some samples and/or more detailed documentation that could expedite my understanding.

2. Similarly, assuming that I want the package to recognize the DATE function of DB2 as far as I am concerned (since I do only syntax parsing), the function could do nothing, maybe return the input parameter as is. What should be therefore the syntax for