How to use it¶

Command Line

java -jar JSQLTranspiler.jar [-d <arg> | --any | --bigquery |
   --databricks | --snowflake | --redshift]      [-D <arg> | --duckdb]
   [-i <arg>] [-o <arg>] [-h]

Java Library Call

import ai.starlake.transpiler.JSQLTranspiler;
String providedSQL="SELECT Nvl(null, 1) a";
String expectedSQL="SELECT Coalesce(null, 1) a";
String result = JSQLTranspiler.transpile(providedSQL, Dialect.AMAZON_REDSHIFT);
assertEquals(expectedSQL, result);

Command Line Options (CLI)¶

-d,–input-dialect <arg> The SQL dialect to parse.

[ANY*, GOOGLE_BIG_QUERY, DATABRICKS, SNOWFLAKE, AMAZON_REDSHIFT]

--any

Interpret the SQL as Generic Dialect [DEFAULT].

--bigquery

Interpret the SQL as Google BigQuery Dialect.

--databricks

Interpret the SQL as DataBricks Dialect.

--snowflake

Interpret the SQL as Snowflake Dialect.

--redshift

Interpret the SQL as Amazon Snowflake Dialect.

-D,–output-dialect <arg> The SQL dialect to write.

[DUCKDB*]

--duckdb: Write the SQL in the Duck DB Dialect [DEFAULT].

-i,–inputFile <arg> The input SQL file or folder.

Read from STDIN when no input file provided.

-o,–outputFile <arg> The out SQL file for the formatted

statements. Create new SQL file when folder provided. Append when existing file provided. Write to STDOUT when no output file provided.

-h,–help Print the help synopsis.

Note

You can provide the SQL Statements as an argument to the program, e.g.

java -jar jsqltranspiler.jar \
    "SELECT Nvl( NULL, 1 ) a;
    SELECT TOP 10 qtysold, sellerid
    FROM sales
    ORDER BY qtysold DESC, sellerid;"