Dev tools · alternatives · 2026
24 alternatives to Trilogy – A Reusable, Composable SQL Experiment
Recipe: Add a semantic layer to SQL; use it drop the requirement for joins/group_by; add in type-checking and a lightweight python-esque import syntax to enable reuse and hierarchical querying. Trilogy is intended to provide an accessible but deep alternative to raw SQL. It offers a new-but-inspired-by-SQL syntax that compiles to various dialects of SQL (with DuckDB as the default). The target audience is people that really like SQL for analytics and data engineering, but want less boilerplate and sharp edges and looser coupling to the DB. Semantic models can be easily shared, composed…
Trilogy is a SQL alternative that adds a semantic layer to reduce boilerplate like joins and group-by clauses. It uses a Python-inspired syntax with type-checking and a reusable import system, compiling to various SQL… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Trilogy – A Reusable, Composable SQL Experiment launched in 2024; newer entries below may have overtaken it.
- 1
- 2
Would love thoughts! Here is the HF page: https://huggingface.co/chatdb/natural-sql-7b
2024 · github.com · its alternatives →
- 3
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
2023 · github.com · its alternatives →
- 4
Using SQL's Turing Completeness to Build Tetris. Contribute to nuno-faria/tetris-sql development by creating an account on GitHub.
2024 · github.com · its alternatives →
- 5
Arctype▲492Supercharged SQL client for developers and teams
2021 · clickhouse.com · its alternatives →
- 6HA
Hi all, we recently open sourced the first version of Hashquery, a Python library which lets you model analytics, DRY up common logic, and execute it against a database or warehouse. We were originally rendering SQL directly for all our queries, but that spiraled out of control with more complex analysis; the SQL needed to be changed sporadically for each new database dialect (BigQuery, Redshift, Aethena, Postgres, etc etc) and the SQL fragments were very challenging to reuse (and so fragments were copy-pasted all over). ~~~ Advantages we think it has over writing SQL by hand: - Queries are…
2024 · hashquery.dev · its alternatives →
- 7
Long story short: We (Dataherald) just open-sourced our entire codebase, including the core engine, the clients that interact with it and the backend application layer for authentication and RBAC. You can now use the full solution to build text-to-SQL into your product. The Problem: modern LLMs write syntactically correct SQL, but they struggle with real-world relational data. This is because real world data and schema is messy, natural language can often be ambiguous and LLMs are not trained on your specific dataset. Solution: The core NL-to-SQL engine in Dataherald is an LLM based agent…
2024 · github.com · its alternatives →
- 8
- 9
My co-worker and I were debugging a SQL issue; having not seen SQL in two years, I embarrassed myself by confusing union vs. join. After this episode, I tried refreshing my SQL memory, but there are few websites that animate SQL for you. Most of them just have a series of images to help you visualize. There are a few tools that are quite good and robust (especially for large/complex use cases) but require installation and are too complex for my simple purpose. So, just created a small tool to help visualise SQL. Most of the animations are just my understanding of how SQL works. Would…
2022 · animatesql.com · its alternatives →
- 10
Hey HN! We are Jonathan & Guy, and we are happy to share a project we’ve been working on. ChartDB is a tool to help developers and data analysts quickly visualize database schemas by generating ER diagrams with just one query. A unique feature of our product is AI-Powered export for easy migration. You can give it a try at https://chartdb.io and find the source code on GitHub. Next steps ---> More AI. We’d love feedback :)
2024 · github.com · its alternatives →
- 11
A Go SQL query builder and struct mapper. Contribute to samonzeweb/godb development by creating an account on GitHub.
2016 · github.com · its alternatives →
- 12
I created a web page to compare different analytical databases (both self-managed and services, open-source and proprietary) on a realistic dataset. It contains 20+ databases, each with installation and data loading scripts. And they can be compared to each other on a set of 43 queries, by data load time or by storage size. There are switches to select different types of databases for comparison - for example, only MySQL compatible or PostgreSQL compatible. If you play with the switches, many interesting details will be uncovered. Full description:…
2022 · benchmark.clickhouse.com · its alternatives →
- 13
Contribute to akdor1154/python-csql development by creating an account on GitHub.
2020 · github.com · its alternatives →
- 14CA
Last year we launched ChartDB OSS (https://news.ycombinator.com/item?id=44972238) - an open-source tool that generates ER diagrams from your database (via query/sql/dbml) without needing direct DB access. Now we’re launching the ChartDB Agent. It helps you design databases from scratch or make schema changes with natural language. You can: - Generate schemas by simply describing them in plain English - Brainstorm new tables, columns, and relationships with AI - Iterate visually in a diagram (ERD) - Deterministically export SQL script Try it out here -…
2025 · app.chartdb.io · its alternatives →
- 15
Define metrics once. Use them everywhere.
Jun 2026 · basedash.com · its alternatives →
- 16
LBADD: An experimental, distributed SQL database. Contribute to tomarrell/lbadd development by creating an account on GitHub.
2019 · github.com · its alternatives →
- 17
Semantic inspector for SQL — catches fan-out double-counting, additivity violations, wrong join keys, and policy breaches before the query runs. Found real bugs in the BIRD/Spider text-to-SQL benchmarks. - sqlsure/sqlsure
Jul 2026 · github.com · its alternatives →
- 18
- 19
Postgres-Backed Drop-in Temporal Replacement. Contribute to dbos-inc/dbosify-py development by creating an account on GitHub.
Jun 2026 · github.com · its alternatives →
- 20
SQL micro-dialect implementation for querying JSON objects. Written purely in Scala. - mmalek06/JsonSql
2020 · github.com · its alternatives →
- 21
Datatune ▲38Modern AI tools use SQL/Code generation agents or RAG to access the user data to perform transformations. However, the drawback is that this doesn't provide row-level intelligence, especially in case of semantic intelligence is required to understand how to perform the transfromations on each row of the data. We've released Datatune (https://github.com/vitalops/datatune) as a tool to let users connect entire user Data with LLMs and Agents, to help users access their entire data with just a prompt. While building Agents for a customer who had large amounts of data, we…
Jan 2026 · github.com · its alternatives →
- 22DS
I played around with GPT-3 to build this demo. Select a public BigQuery dataset and describe your query in natural English, then edit the generated SQL as needed and execute it. https://app.tabbydata.com/sql-assistant-demo
2021 · its alternatives →
- 23
Query C++ codebases using SQLite. Contribute to frabert/ClangQL development by creating an account on GitHub.
2021 · github.com · its alternatives →
- 24
An Interpreter for Extended Relational Algebra (Scheme based) - scvalencia/Coddie
2016 · github.com · its alternatives →
Also compare
Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →