Instant SQL for results as you type in DuckDB UI

Re:Instant SQL for results as you type in DuckDB UI by XCSme on Thursday April 24, 2025 @10:39AM (#43783387)

That's actually not a bad idea, to have LLM autocomplete when you write queries, especially if you first add a comment at the top saying what you want to achieve:

// Select all orders for users registered in last year, and compute average earnings per user

SELECT ...

[ Parent | on HN ]

Re:Instant SQL for results as you type in DuckDB UI by ako on Friday April 25, 2025 @04:32AM (#43791484)

That already works in windsurf, I’ve created unit tests in go, where I just wrote a short comment in the unit test what data to query and windsurf would autocomplete with the full sql.

[ Parent | on HN ]

Re:Instant SQL for results as you type in DuckDB UI by XCSme on Friday April 25, 2025 @05:42AM (#43791852)

I mean, all LLMs do this already, but I never saw LLM autocomplete in a db tool (e.g. phpmyamdin, MongoDB Compass, etc).

[ Parent | on HN ]