How to use it

Compile from Source Code

You will need to have JDK 8 or JDK 11 installed.

git clone https://github.com/prestodb/sql.git
cd sql
mvn install

Build Dependencies

<dependency>
    <groupId>com.facebook.presto</groupId>
    <artifactId>presto-coresql</artifactId>
    <version>0.1</version>
</dependency>

Parse a SQL Statements

Parse the SQL Text into Java Objects:

import com.facebook.coresql.parser.AstNode;
import com.facebook.coresql.parser.ParserHelper;
import com.facebook.coresql.parser.Unparser;

String sqlStr = "select 1 from dual where a=b";
AstNode ast = ParserHelper.parseStatement(sqlStr);
String unparsedSqlStr = Unparser.unparse(ast);