SQL: 2023 is finished: Here is what's new

1. prql

   1 121 10,052 9.7 Rust

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

   

   I really like what PRQL[0] is doing. Fixes a lot of the unfortunate SQL syntax. My impossible dream is that after years of language stability, Postgres could make it a first party query language, and then all of the dominoes would start to fall.

   [0] https://prql-lang.org/

2. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

3. TablaM

   2 154 191 0.0 Rust

   The practical relational programing language for data-oriented applications

   

   There are many, but most never go further than SQL (ie: Are just a "query" language).

   I'm trying to do it for a "general purpose" language where array + relational + functional + imperative can work together:

   https://tablam.org

   ---

   One of the biggest damage that SQL has caused is that SQL is so bad as being a programming language, is not good enough DSL and is weirdly the only game in town.

   This is the deal with RDBMS. Is like: "Everyone implement a wild flavor a VM, sometimes JVM, .NET VM, Web Assembly, etc, but all use a slight variation of Java"

   Is like the reverse of how things are done!

4. sqlglot

   3 58 6,998 9.9 Python

   Python SQL Parser and Transpiler

   

   sqlglot might be what you are looking for.

   https://github.com/tobymao/sqlglot

Suggest a related project