Re:Instant SQL for results as you type in DuckDB UI
by ayhanfuat on Thursday April 24, 2025 @10:21AM
(#43783155)
CTE inspection is amazing. I spend too much time doing that manually.
[ Parent
| on HN ]
Re:Instant SQL for results as you type in DuckDB UI
by hamilton on Thursday April 24, 2025 @11:13AM
(#43783801)
Me too (author of the post here). In fact, I was watching a seasoned data engineer at MotherDuck show me how they would attempt to debug a regex in a CTE. As a longtime SQL user, I felt the pain immediately; haven't we all been there before? Instant SQL followed from that.
Re:Instant SQL for results as you type in DuckDB UI
by RobinL on Thursday April 24, 2025 @01:48PM
(#43785474)
Agree, definitely amazing feature. In the Python API you can get somewhere close with this kind of thing:
input_data = duckdb.sql("SELECT * FROM read_parquet('...')")
step_1 = duckdb.sql("SELECT ... FROM input_data JOIN ...")
step_2 = duckdb.sql("SELECT ... FROM step_1")
final = duckdb.sql("SELECT ... FROM step_2;")