2 ms·
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 Logfil
by tstack 1y ago
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 https://prql-lang.org
[2] - https://lnav.org/2024/03/29/prql-support.html https://lnav.org/2024/03/29/prql-support.html
- mritchie712 1y agothere's a PRQL extension for duckdb: https://community-extensions.duckdb.org/extensions/prql.html https://community-extensions.duckdb.org/extensions/prql.html
- RyanHamilton 1y agoIf you want to get started with prql check out qstudio https://www.timestored.com/qstudio/prql-ide https://www.timestored.com/qstudio/prql-ide it allows running prql easily against mysql postgresql duckdb etc