Python SQL Parser and Transpiler.

SQLGlot is a no-dependency SQL parser, transpiler, optimizer, and engine. It can be used to format SQL or translate between 31 different dialects like DuckDB, Presto / Trino, Spark / Databricks, Snowflake, and BigQuery. It aims to read a wide variety of SQL inputs and output syntactically and semantically correct SQL in the targeted dialects.

• SQLGlot @ GitHub.

tbls is a CI-Friendly tool to document a database, written in Go.

Related contents:

• Liam ERD.

📊 Cube — The Semantic Layer for Building Data Applications. The Universal Semantic Layer.

Build trust with a semantic layer. Connect siloed data, define consistent metrics, and power AI and analytics with context.

Cube is the semantic layer for building data applications. It helps data engineers and application developers access data from modern data stores, organize it into consistent definitions, and deliver it to every application.

Cube was designed to work with all SQL-enabled data sources, including cloud data warehouses like Snowflake or Google BigQuery, query engines like Presto or Amazon Athena, and application databases like Postgres. Cube has a built-in relational caching engine to provide sub-second latency and high concurrency for API requests.

• Cube @ GitHub.
• #264.exe - GraphQL: Votre nouveau BFF par Christophe Blefari @ <ifttd>.
• le semantic layer va vous plaire @ Florent J.'s LinkedIn :fr:.

Your Data Pipeline, Simplified. GlareDB: An analytics DBMS for distributed data.

Data exists everywhere: your laptop, Postgres, Snowflake and as files in S3. It exists in various formats such as Parquet, CSV and JSON. Regardless, there will always be multiple steps spanning several destinations to get the insights you need.

GlareDB is designed to query your data wherever it lives using SQL that you already know.

• GlareDB @ GitHub
• What the Heck is GlareDB? @ HackerNoon.