3 ms·
DuckDb is missing a killer feature by not having a pipe syntax like kusto or google's pipe query syntax. Why is it a killer feature? First of all, LLMs complet
by motoboi 1y ago
DuckDb is missing a killer feature by not having a pipe syntax like kusto or google's pipe query syntax.
Why is it a killer feature? First of all, LLMs complete text from left to right. That alone is a killer feature.
But for us meatboxes with less compute power, pipe syntax allow (much better) code completion.
Pipe syntax is delightful to work with and makes going back to SQL a real bummer moment (please insert meme of Kate Perry kissing the earth here).
- ergest 1y agoThere’s an extension for that https://github.com/ywelsch/duckdb-psql https://github.com/ywelsch/duckdb-psql
- Philpax 1y agoAlso https://github.com/ywelsch/duckdb-prql https://github.com/ywelsch/duckdb-prql (by the same author!)
- gervwyk 1y agoNothing comes close to the power of mongodb aggression pipelines.. when used in production apps it reduces the amount of code significantly for us by doing data modeling as close as possible to the source
- sterlinm 1y ago[grizzled kdb+ user considers starting an argument but then thinks better of it]
- hantusk 1y agoCTEs go a long way towards left to right readability while keeping everything standard SQL.