5 ms·

I'm unconvinced the syntax makes a genuine difference. But always interesting to see what folks come up with! Some notable others: PreQL/Trilogy - https://git

I'm unconvinced the syntax makes a genuine difference. But always interesting to see what folks come up with! Some notable others: PreQL/Trilogy - https://github.com/trilogy-data/pytrilogy https://github.com/trilogy-data/pytrilogy https://news.ycombinator.com/item?id=40728938 https://news.ycombinator.com/item?id=40728938 Malloy -https://www.malloydata.dev/ https://www.malloydata.dev/ https://github.com/malloydata/malloy https://github.com/malloydata/malloy https://news.ycombinator.com/item?id=30053860 https://news.ycombinator.com/item?id=30053860 PRQL - https://prql-lang.org/ https://prql-lang.org/ https://github.com/PRQL/prql https://github.com/PRQL/prql https://news.ycombinator.com/item?id=36866861 https://news.ycombinator.com/item?id=36866861

anonzzzies 1y ago
> I'm unconvinced the syntax makes a genuine difference Syntax not, but datalog (-ish) does. It's a more natural way (imho of course) to query data. Far more complex queries with less mental overload.
pbowyer 1y ago
EdgeQL - https://www.geldata.com/showcase/edgeql https://www.geldata.com/showcase/edgeql
Pxtl 1y ago
SQL's shortcomings aren't just syntax and the convention of SCREAMING KEYWORDS. There's the lack of algebraic types (particularly galling given the bizarre three-value boolean algebra created by its strange null-handling), the poor composability (why is creating a reusable predicate filter so hard?), the lack of any coherent module system, etc. The fact that something as simple as a tree is such a nuisance in a "relational" database is ludicrous.