{"repo":"starlake-ai/jsqltranspiler","free":true,"listed":false,"github":"https://github.com/starlake-ai/jsqltranspiler","clone":"git clone https://github.com/starlake-ai/jsqltranspiler.git","description":"Rewrite BigQuery, Redshift, Snowflake and Databricks queries into DuckDB compatible SQL (with deep transformation of functions, data types and format characters) using Java.","language":"Java","stars":73,"topics":["bigquery","databricks","duckdb","query","redshift","rewrite","snowflake","transpiler","java","abstract-syntax-tree"],"license":null,"category":"databases-storage","readme_excerpt":"JSQLTranspiler - Transpile Dialect, Resolve Columns, Show Lineage, Refactor Queries A pure Java stand-alone SQL Transpiler, Column- and Lineage Resolver for translating various large RDBMS SQL Dialects into a few smaller RDBMS Dialects for Unit Testing. Based on JSQLParser. Supports SELECT queries as well as INSERT , UPDATE , DELETE and MERGE statements. Internal Functions will be rewritten based on the actual meaning and purpose of the function (since the DuckDB Any() function does not necessarily behave like the RDBMS specific Any() ). Respecting different function arguments count, order and type. Rewrite of Window- and Aggregate-Functions with full coverage of the RDBMS specific published samples. The matrix of supported features and functions is shared on Google Sheets. Dialects Input : Google BigQuery, Databricks, Snowflake, Amazon Redshift Output : DuckDB Transpile Example Google BigQuery specific SQL will become DuckDB compatible SQL Column Lineage Example For the simplified schema definition and the given query the ResultSetMetaData return a list of JdbcColumns, each traversable using the TreeNode interface. The resulting Column Lineage can be illustrated as: Resolve Star Operator Example For the simplified schema definition and the given query with Star Operators the query will be resolved and (optionally rewritten into): Alternatively, the information about returned columns can be fetched as JDBC ResultsetMetaData (without actually executing this query): PipedSQL Ex","default_branch":null,"files":null,"tree":[],"storefront":"/r/starlake-ai","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/starlake-ai/jsqltranspiler/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}