SQL is pretty good all things considered.
But I've always looked out for languages that can represent relational algebra concepts more directly. Maybe CozoaDB is close, though still immature. Any recommendations?
But I've always looked out for languages that can represent relational algebra concepts more directly. Maybe CozoaDB is close, though still immature. Any recommendations?
https://www.dcs.warwick.ac.uk/~hugh/TTM/DTATRM.pdf
The only problem there is that you might want to use a D language, and well. You can't. There was a product called Dataphor which one can find some writeups on but, baffling though I find this, there are no robust open-source relational databases which use a D language.
“select id, date from orders” is orders[“id”, “date”].
It’s meant for in-memory datasets but the syntax could be extended to work for other backends. I’m not sure if anyone is working on that.