News for hackers. Stuff that matters.
Re:Instant SQL for results as you type in DuckDB UI by motoboi on Thursday April 24, 2025 @03:29PM (#43786534)
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).

Re:Instant SQL for results as you type in DuckDB UI by gervwyk on Thursday April 24, 2025 @04:16PM (#43787027)
Nothing 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
Re:Instant SQL for results as you type in DuckDB UI by sterlinm on Friday April 25, 2025 @08:45AM (#43793005)
[grizzled kdb+ user considers starting an argument but then thinks better of it]
Re:Instant SQL for results as you type in DuckDB UI by ergest on Thursday April 24, 2025 @03:43PM (#43786703)
There’s an extension for that https://github.com/ywelsch/duckdb-psql
Re:Instant SQL for results as you type in DuckDB UI by Philpax on Thursday April 24, 2025 @05:40PM (#43787821)
Also https://github.com/ywelsch/duckdb-prql (by the same author!)
Re:Instant SQL for results as you type in DuckDB UI by hantusk on Thursday April 24, 2025 @04:25PM (#43787103)
CTEs go a long way towards left to right readability while keeping everything standard SQL.