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
@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 ()