13 ms·
TIL about Verse looks cool I'll have to check it out. > SQL is not a pipeline, it is a graph. Maybe it's both? and maybe there will always be hard-to-express
by data_ders 7mo ago
TIL about Verse looks cool I'll have to check it out.
> SQL is not a pipeline, it is a graph.
Maybe it's both? and maybe there will always be hard-to-express queries in SQL, and that's ok?
the RDBMS's relational model is certainly a graph and joins accordingly introduce complexity.
For me, just as creators of the internet regret that subdomains come before domains, I really we could go back in time and have `FROM` be the first predicate and not `SELECT`. This is much more intuitive and lends itself to the idea of a pipeline: a table scan (FROM) that is piped to a projection (SELECT).
- thesz 7mo agoPipeline is a specific kind of a graph. Yes, there will always be hard-to-express queries, the question is how far can we go?