zed
zed copied to clipboard
A novel data lake based on super-structured data
The following query doesn't currently work in SuperDB but does work in Postgres. ``` $ super -version Version: 7f23f6560 $ super -c "with cte1(xxx) as (Select i as j from...
While basic CTE functionality was added for SuperSQL in #5932, recursive CTEs are not yet supported, such as this simple example often used to explain the concept in SQL docs:...
There's SUP messages inside this BSUP API exchange which caused a breakage. ## Details Repro is with super commit 7f23f65. The changes in #6009 made it such that newer super...
Most SQL users are familiar with how the standard makes absolutely no guarantee on the order of the rows returned in absence of an explicit `ORDER BY`. That said, particular...
Per [Postgres docs](https://www.postgresql.org/docs/current/queries-union.html), SQL offers `UNION,` `INTERSECT`, and `EXCEPT` that perform set operations. SuperSQL already has partial support for `UNION`, so support for the others should be added as well....