Transpile Any SQL to PostgreSQL Dialect

• transqlate

  3 - -

From the "Roadmap" section of the README:

> more source dialects : mysql, mssql, sybase, etc.

https://gitlab.com/dalibo/transqlate#roadmap

• libpg_query

  13 1,068 8.8 C

  C library for accessing the PostgreSQL parser outside of the server environment

  

This in combination with [pg_query](https://github.com/pganalyze/libpg_query) could be a very powerful combination that allows writing generic static analyzers.

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• prql

  106 9,427 9.9 Rust

  PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement

  

• babelfish_extensions

  7 260 9.7 TSQL

  Babelfish for PostgreSQL provides the capability for PostgreSQL to work with applications written for Microsoft SQL Server. Babelfish understands the SQL Server wire-protocol and T-SQL, the Microsoft SQL Server query and procedural language, so you don’t have to switch database drivers or rewrite all of your application queries.

  

[2] https://github.com/babelfish-for-postgresql/babelfish_extens...

• babelfish_extens

  1 - -

[2] https://github.com/babelfish-for-postgresql/babelfish_extens...

• sqlglot

  56 5,511 9.9 Python

  Python SQL Parser and Transpiler

Recommend checking out https://github.com/tobymao/sqlglot if you are interested in this capability for other SQL dialects

Tools like this are helpful for:

- Rendering SQL in a consistent way, eg for snapshot testing

Suggest a related project