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

git clone https://github.com/prestodb/sql.git
cd sql
gradle build

Build Dependencies¶

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

<repositories>
    <repository>
        <id>presto-coresql-snapshots</id>
        <snapshots>
            <enabled>true</enabled>
        </snapshots>
        <url>https://oss.sonatype.org/content/groups/public/</url>
    </repository>
</repositories>

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

repositories {
    mavenCentral()
}

dependencies {
    implementation 'com.facebook.presto:presto-coresql:0.1'
}

repositories {
    maven {
        url = uri('https://oss.sonatype.org/content/groups/public/')
    }
}

dependencies {
    implementation 'com.facebook.presto:presto-coresql:0.2-SNAPSHOT'
}

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);