| ▲ | mcdonje 2 days ago | |
There's some good stuff in here. I didn't know about the issues an aggregation in a CTE can cause and haven't used EXISTS much. Regarding recursive CTEs, you might be interested in how DuckDb evolved them with USING KEY: https://duckdb.org/2025/05/23/using-key | ||
| ▲ | scythmic_waves 2 days ago | parent [-] | |
That was also a great read, thanks! | ||