Look here for more information and examples: https://github.com/JSQLParser/JSqlParser/wiki.
JSqlParser is dual licensed under LGPL V2.1 or Apache Software License, Version 2.0.
Please provide feedback on:
- API changes: extend visitor with return values (JSQLParser#901)
- Released version 4.4 of JSqlParser
- The array parsing is the default behaviour. Square bracket quotation has to be enabled using a parser flag (CCJSqlParser.withSquareBracketQuotation).
- due to an API change the version will be 3.0
- JSqlParser uses now Java 8 at the minimum
More news can be found here: https://github.com/JSQLParser/JSqlParser/wiki/News.
General SQL Parser looks pretty good, with extended SQL syntax (like PL/SQL and T-SQL) and java + .NET APIs. The tool is commercial (license available online), with a free download option.
JSqlParser is a SQL statement parser. It translates SQLs in a traversable hierarchy of Java classes. JSqlParser is not limited to one database but provides support for a lot of specials of Oracle, SqlServer, MySQL, PostgreSQL ... To name some, it has support for Oracles join syntax using (+), PostgreSQLs cast syntax using ::, relational operators like != and so on.
If you need help using JSqlParser feel free to file an issue or contact me.
To help JSqlParser's development you are encouraged to provide
- feedback
- bugreports
- pull requests for new features
- improvement requests
- fund new features or sponsor JSqlParser (Sponsor)
Please write in English, since it's the language most of the dev team knows.
Any requests for examples or any particular documentation will be most welcome.
- support for named windows in window expressions:
SELECT sum(c) OVER winName FROM mytable WINDOW winName AS (PARTITION BY pcol)
Additionally, we have fixed many errors and improved the code quality and the test coverage.
- Release Notes
- Modifications before GitHub's release tagging are listed in the Older Releases page.
As the project is a Maven project, building is rather simple by running:
mvn packageSince 4.2, alternatively Gradle can be used
gradle buildThe project requires the following to build:
- Maven (or Gradle)
- JDK 8 or later. The JAR will target JDK 8, but the version of the maven-compiler-plugin that JSqlParser uses requires JDK 8+
This will produce the jsqlparser-VERSION.jar file in the target/ directory (build/libs/jsqlparser-VERSION.jar in case of Gradle).
To build this project without using Maven or Gradle, one has to build the parser by JavaCC using the CLI options it provides.
Refer to the Visualize Parsing section to learn how to run the parser in debug mode.
Recently a checkstyle process was integrated into the build process. JSqlParser follows the sun java format convention. There are no TABs allowed. Use spaces.
public void setUsingSelect(SubSelect usingSelect) {
this.usingSelect = usingSelect;
if (this.usingSelect != null) {
this.usingSelect.setUseBrackets(false);
}
}This is a valid piece of source code:
- blocks without braces are not allowed
- after control statements (if, while, for) a whitespace is expected
- the opening brace should be in the same line as the control statement
JSQLParser is deployed at Sonatype open source maven repository. Starting from now I will deploy there. The first snapshot version there will be 0.8.5-SNAPSHOT. To use it this is the repository configuration:
<repositories>
<repository>
<id>jsqlparser-snapshots</id>
<snapshots>
<enabled>true</enabled>
</snapshots>
<url>https://oss.sonatype.org/content/groups/public/</url>
</repository>
</repositories>These repository releases will be synchronised to Maven Central. Snapshots remain at Sonatype.
And this is the dependency declaration in your pom:
<dependency>
<groupId>com.github.jsqlparser</groupId>
<artifactId>jsqlparser</artifactId>
<version>4.4</version>
</dependency>