有没有任何替代GSP（一般SQL解析器）？ [英] Are there any alternatives to GSP (General SQL Parser)?
问题描述
一般SQL解析器（GSP）是一个功能丰富的SQL解析器（在我使用它的程度上），允许修改SQL通过改变解析树本身以鲁棒的方式声明。此外，它支持最流行的数据库的SQL风格。然而，一个大的减去GSP是，它是可怕的，简单可怕的，记录：javadoc的大部分由原始方法和属性名称（几乎没有评论），没有真正没有文档概述核心功能和意义最重要的性质和方法;并且似乎他们只是暴露了一切作为公共成员，使得API很难通过查看它来抓住。
唯一的文档是一些实际的例子，你必须自己反向工程的API的意义。
General SQL Parser (GSP) is a quite feature rich SQL parser (to the extent that I have played with it) that allows for modifying SQL statements in a robust way by altering the parse tree itself. Furthermore, it supports SQL flavors for most popular databases. However, a big minus with GSP is that it is horribly, simply horribly, documented: the javadoc's consist mostly of the raw method and property names (with almost no comments), there are really no documentation that outlines the core functionality and the meaning of most important properties and methods; and it seems like they have just exposed everything as public members, making the API very hard to grasp by looking at it. The only documentation is a bunch of practical examples from which you have to reverse-engineer the meaning of the API calls yourself.
我不喜欢生产生产关键软件与这样的图书馆。因此，由于上述原因，我宁愿使用另一个解析器，但不幸找不到任何替代（对于java）具有类似的功能和支持多个SQL风格。
I do not like producing production critical software with a library like that. So due to the above, I would prefer using another parser, but have unfortunately failed to find any alternatives (for java) with similar functionality and support for multiple SQL flavors.
推荐答案
我是James从gudu软件开发了一般SQL解析器）。由于Oracle，SQL Server，DB2，MySQL，Teradata，PostgreSQL等各种数据库的SQL语言的复杂性，我们创建的支持这些数据库的SQL Parser也有点复杂。
I'm James from gudu software(company that developed General SQL Parser). Due to the complexity of SQL language of various databases such as Oracle, SQL Server, DB2, MySQL, Teradata, PostgreSQL, the SQL Parser we created to support those databases was a little bit complicated as well.
我不得不承认通用SQL Parser的文档真的很差，也许我们应该更努力地在文档而不是SQL库本身。
I have to admit that the document of General SQL Parser is really poor, Maybe we should put more effort on the document rather than SQL library itself.
Fortunately, we have created a rich set of demos to help people getting started quickly.
如果仍然对使用常规SQL解析器感兴趣，请让我知道（我可以通过info@sqlparser.com）。我们很乐意提供帮助。
If are still interested in using General SQL Parser, please kindly let me know(I can be reached via info@sqlparser.com). We are happy to help.
这篇关于有没有任何替代GSP（一般SQL解析器）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
