YASPY (Yet Another SQL parser in PYthon)
What is it?
Yaspy is a python module built for the purpose of breaking down various SQL queries into it's component parts
The current version is 0.2. The module can be found at yaspy.sourceforge.net. Cutting edge versions can be retrieved from the svn repository https://yaspy.svn.sourceforge.net/svnroot/yaspy
Currently, yaspy must be installed manually by either placing it in the python directory path or in the working directory of the project you wish to use it with. You can then use it by calling "import yaspy" in your python script.
Yaspy parses SQL queries via use of a global function called "parse". Calling this function with a string SQL argument returns an appropriate statement object