Re:Instant SQL for results as you type in DuckDB UI
by mritchie712 on Thursday April 24, 2025 @10:46AM
(#43783476)
a fun function in duckdb (which I think they're using here) is `json_serialize_sql`. It returns a JSON AST of the SQL
[ Parent
| on HN ]
Re:Instant SQL for results as you type in DuckDB UI
by hamilton on Thursday April 24, 2025 @11:04AM
(#43783697)
Indeed, we are! We worked with DuckDB Labs to add the query_location information, which we're also enriching with the tokenizer to draw a path through the AST to the cursor location. I've been wanting to do this since forever, and now that we have it, there's actually a long tail of inspection / debugging / enrichment features we can add to our SQL editor.
Re:Instant SQL for results as you type in DuckDB UI
by krferriter on Thursday April 24, 2025 @11:22AM
(#43783889)
This is a very cool feature. I don't know how useful it is or how I'd use it right now but I think I am going to get into some benchmarking and performance tweaking soon and this could be handy.