Our great sponsors
-
prql
PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
-
InfluxDB
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.
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/
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!
sqlglot might be what you are looking for.
https://github.com/tobymao/sqlglot