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!)
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).