任务：新的SQL路由函数

[leader-us]

难度S级别，持续改进预计半年以上，需要思维严谨，熟悉和感兴趣SQL解析的牛人来实现，大家完善

函数一：实现简单高效的SQL扫描，只返回回SQL中的Table信息，以及每个Table字符串结束的位置，用于下一步深入分析
如SQL =select * from tablea A where A.xx= bbb left join tableb B ....
则返回结果
tablea,alias A , indexEnd 22
tableb alias B indexEnd 33

函数二：
深入分析
返回
tablea condition:s xx= bbb ,select colums:*
joins: tablea.xx with tableb.yyy

[forchid]

我计划采用h2database的SQL parser来实现，作为Mycat-2.0内置的parser.
H2 SQL 参考：http://www.h2database.com/html/grammar.html

[apachemycat]

VoltDB uses our own fork of modules from the HSQL project within our product.
Most of VoltDB's SQL DDL and SQL statement parsing uses HSQL's parser.
Various tools and utilites in the VoltDB package also use other components from the HSQL project, such as its tar file interface.

Finally, to answer your specific question, the VoltDB test frameworks use a database engine closely based on HSQL's to generate baseline results for comparison with VoltDB results.
THIS aspect of HSQL -- its use as an alternative "backend" database engine for testing -- is usually the intent when the term "HSQL" is used in VoltDB test code.