JSQLTranspiler 0.2-SNAPSHOT API

    Base Package: ai.starlake.jsqltranspiler

    Base

    JSQLTranspiler.Dialect

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

    The enum Dialect.

    JSQLExpressionTranspiler

    extends: ExpressionDeParser provides: BigQueryExpressionTranspiler, DatabricksExpressionTranspiler, RedshiftExpressionTranspiler, SnowflakeExpressionTranspiler

    The type Expression transpiler.
    JSQLExpressionTranspiler (transpiler, buffer)
    JSQLTranspiler transpiler
    StringBuilder buffer
    isDatePart (expression, dialect) → boolean
    Expression expression
    Dialect dialect
    returns boolean
    isDateTimePart (expression, dialect) → boolean
    Expression expression
    Dialect dialect
    returns boolean
    hasTimeZoneInfo (timestampStr) → boolean
    String timestampStr
    returns boolean
    hasTimeZoneInfo (timestamp) → boolean
    Expression timestamp
    returns boolean
    rewriteDateLiteral (p, dateTimeType) → Expression
    Expression p
    DateTime dateTimeType
    returns Expression
    @SuppressWarnings
    visit (function)
    Function function
    visit (function)
    AnalyticExpression function
    visit (extractExpression)
    ExtractExpression extractExpression
    visit (stringValue)
    StringValue stringValue
    visit (hexValue)
    HexValue hexValue
    convertUnicode (input) → String
    String input
    returns String
    visit (castExpression)
    CastExpression castExpression
    visit (structType)
    StructType structType
    rewriteType (colDataType) → ColDataType
    ColDataType colDataType
    returns ColDataType
    warning (s)
    String s
    convertByteStringToUnicode (byteString) → String
    String byteString
    returns String
    castDateTime (expression) → Expression
    String expression
    returns Expression
    castDateTime (expression) → Expression
    Expression expression
    returns Expression
    @SuppressWarnings
    castDateTime (expression) → Expression
    DateTimeLiteralExpression expression
    returns Expression
    @SuppressWarnings
    castDateTime (expression) → Expression
    CastExpression expression
    returns Expression
    @SuppressWarnings
    castDateTime (expression) → Expression
    StringValue expression
    returns Expression
    castInterval (expression) → Expression
    String expression
    returns Expression
    castInterval (expression) → Expression
    Expression expression
    returns Expression
    castInterval (expression) → Expression
    StringValue expression
    returns Expression
    castInterval (expression) → Expression
    CastExpression expression
    returns Expression
    castInterval (expression) → Expression
    IntervalExpression expression
    returns Expression

    JSQLTranspiler

    extends: SelectDeParser provides: BigQueryTranspiler, DatabricksTranspiler, RedshiftTranspiler, SnowflakeTranspiler

    The type Jsql transpiler.

    Instantiates a new transpiler. | Class expressionTranspilerClass

    JSQLTranspiler ()
    getAbsoluteFile (filename) → File
    Resolves the absolute File from a relative filename, considering $HOME variable and “~”
    String filename | filename the relative filename
    returns File | the resolved absolute file
    getAbsoluteFileName (filename) → String
    Resolves the absolute File Name from a relative filename, considering $HOME variable and “~”
    String filename | filename the relative filename
    returns String | the resolved absolute file name
    @SuppressWarnings
    main (args)
    The entry point of application.
    String args | args the input arguments
    @SuppressWarnings
    transpileQuery (qryStr, dialect) → String
    Transpile a query string in the defined dialect into DuckDB compatible SQL.
    String qryStr | qryStr the original query string
    Dialect dialect | dialect the dialect of the query string
    returns String | the transformed query string
    transpile (sqlStr, outputFile)
    Transpile a query string from a file or STDIN and write the transformed query string into a file or STDOUT.
    String sqlStr | sqlStr the original query string
    File outputFile | outputFile the output file, writing to STDOUT when not defined
    transpile (select) → String
    Transpile string.
    Select select | select the select
    returns String | the string
    transpileGoogleBigQuery (select) → String
    Transpile google big query string.
    Select select | select the select
    returns String | the string
    transpileDatabricksQuery (select) → String
    Transpile databricks query string.
    Select select | select the select
    returns String | the string
    transpileSnowflakeQuery (select) → String
    Transpile snowflake query string.
    Select select | select the select
    returns String | the string
    transpileAmazonRedshiftQuery (select) → String
    Transpile amazon redshift query string.
    Select select | select the select
    returns String | the string
    getResultBuilder () → StringBuilder
    Gets result builder.
    returns StringBuilder | the result builder
    visit (top)
    Top top
    visit (tableFunction)
    TableFunction tableFunction

    uery

    BigQueryExpressionTranspiler

    extends: JSQLExpressionTranspiler

    BigQueryExpressionTranspiler (transpiler, buffer)
    JSQLTranspiler transpiler
    StringBuilder buffer

    BigQueryTranspiler

    extends: JSQLTranspiler

    BigQueryTranspiler ()

    bricks

    DatabricksExpressionTranspiler

    extends: JSQLExpressionTranspiler

    DatabricksExpressionTranspiler (transpiler, buffer)
    JSQLTranspiler transpiler
    StringBuilder buffer

    DatabricksTranspiler

    extends: JSQLTranspiler

    DatabricksTranspiler ()

    hift

    RedshiftExpressionTranspiler

    extends: JSQLExpressionTranspiler

    RedshiftExpressionTranspiler (transpiler, buffer)
    JSQLTranspiler transpiler
    StringBuilder buffer
    @SuppressWarnings
    visit (function)
    Function function
    visit (column)
    Column column
    toFormat (s) → String
    String s
    returns String

    RedshiftTranspiler

    extends: JSQLTranspiler

    RedshiftTranspiler ()

    flake

    SnowflakeExpressionTranspiler

    extends: JSQLExpressionTranspiler

    SnowflakeExpressionTranspiler (transpiler, buffer)
    JSQLTranspiler transpiler
    StringBuilder buffer

    SnowflakeTranspiler

    extends: JSQLTranspiler

    SnowflakeTranspiler ()