jsqltranspiler

Query translator

Translates large RDBMS query dialects into smaller dialects for unit testing and development

Rewrite BigQuery, Redshift, Snowflake and Databricks queries into DuckDB compatible SQL (with deep transformation of functions, data types and format characters) using Java.

GitHub

33 stars
5 watching
4 forks
Language: Java
last commit: about 1 month ago
Linked from 1 awesome list

abstract-syntax-treebigquerycolumndatabricksduckdbjavalineagequeryredshiftresolverrewritesnowflaketranspiler

Backlinks from these awesome lists:

Related projects:

Repository Description Stars
aksw/sparql2nl Converts SPARQL queries to natural language expressions. 42
smartdataanalytics/sparqlify Tools for converting SPARQL queries into equivalent SQL queries to support integration with relational databases. 124
buremba/universql Allows Snowflake users to execute queries on local files without needing a running warehouse 119
stch-library/sql A Clojure-based DSL for building SQL queries and statements. 41
dkuppitz/sparql-gremlin A compiler tool that transforms SPARQL queries into Gremlin traversals 71
twilmes/sql-gremlin Translates SQL queries into Gremlin queries to query a graph database 74
keramas/mssqli-duet A tool designed to extract domain users from Active Directory environments by exploiting SQL injection vulnerabilities in MSSQL databases. 93
swirrl/matcha An in-memory graph query engine with a SPARQL-like DSL for querying Linked Data Models 22
cfabianski/json_translate A Rails I18n library for translating model attribute values using PostgreSQL's JSONB datatype or MySQL's JSON datatype 111
cfabianski/hstore_translate A Rails I18n library that uses PostgreSQL's hstore datatype to translate model attribute values. 11
schibsted/jslt A JSON query and transformation language 641
tatut/specql A Clojure library that generates and executes common PostgreSQL queries with minimal boilerplate code. 132
theseus-rs/rsql A command-line interface for interacting with various relational databases 135