News for hackers. Stuff that matters.
Re:Instant SQL for results as you type in DuckDB UI by tstack on Thursday April 24, 2025 @02:22PM (#43785829)
The PRQL[1] syntax is built around pipelines and works pretty well.

I added a similar "get results as you type" feature to the SQLite integration in the Logfile Navigator (lnav)[2]. When entering PRQL queries, the preview will show the results for the current and previous stages of the pipeline. When you move the cursor around, the previews update accordingly. I was waiting years for something like PRQL to implement this since doing it with regular SQL requires more knowledge of the syntax and I didn't want to go down that path.

[1] - https://prql-lang.org [2] - https://lnav.org/2024/03/29/prql-support.html

Re:Instant SQL for results as you type in DuckDB UI by mritchie712 on Thursday April 24, 2025 @02:50PM (#43786107)
Re:Instant SQL for results as you type in DuckDB UI by RyanHamilton on Thursday April 24, 2025 @05:23PM (#43787665)
If you want to get started with prql check out qstudio https://www.timestored.com/qstudio/prql-ide it allows running prql easily against mysql postgresql duckdb etc