Advanced Query Manipulation with MySQL Proxy
Kay Roepke (Sun Microsystems)
From the official conference description at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7040
Currently MySQL Proxy only comes with an incomplete tokenizer for a subset of the MySQL dialect.
Many use cases require more knowledge about the query that a stream of tokens can provide and users are force to create their own parsers, most of which are handwritten and simplistic, in Lua.
While this is often sufficient for special cases and specific applications, it cannot serve as an extensible and robust framework.
For the purpose of query formatting in the MySQL Enterprise Monitor I have written a new parser using ANTLR, where I am a committer in the project. Due to the nature of ANTLR generated recognizers, it is possible to target different implementation languages with little effort and thus has been integrated with
[]