Re:Instant SQL for results as you type in DuckDB UI
by XCSme on Thursday April 24, 2025 @10:07AM
(#43782990)
I hope this doesn't work with DELETE queries.
[ Parent
| on HN ]
Re:Instant SQL for results as you type in DuckDB UI
by falcor84 on Thursday April 24, 2025 @10:20AM
(#43783141)
Maybe in the next version they could also implement support for DROP, with autocorrect for the nearest (not yet dropped) table name.
Re:Instant SQL for results as you type in DuckDB UI
by clgeoio on Thursday April 24, 2025 @10:26AM
(#43783208)
LLM powered queries that run in Agent mode so it can answer questions of your data before you know what to ask.
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 ...
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.
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).
Re:Instant SQL for results as you type in DuckDB UI
by Covenant0028 on Thursday April 24, 2025 @07:56PM
(#43788804)
Vibe SQLing is where it's at
Re:Instant SQL for results as you type in DuckDB UI
by krferriter on Thursday April 24, 2025 @11:24AM
(#43783905)
DELETED 0 rows. Did you mean `where 1=1`? (click accept to re-run with new where clause)
Re:Instant SQL for results as you type in DuckDB UI
by munk-a on Thursday April 24, 2025 @01:43PM
(#43785427)
Or, for extra fun, it auto completes to DROP TRIGGER and just drops a single random trigger from your database. It'll help counter automation fears by ensuring your DBAs get to have a wonderful weekend on payroll where, very much in the easter spirit, they can hunt through the DB looking for the one thing that should be there but isn't!
Re:Instant SQL for results as you type in DuckDB UI
by falcor84 on Thursday April 24, 2025 @02:05PM
(#43785653)
Wow, that's perhaps the most nefarious version of chaos engineering I had ever heard of. Kudos!
Re:Instant SQL for results as you type in DuckDB UI
by matsonj on Thursday April 24, 2025 @10:51AM
(#43783534)
for clarity: Instant SQL won't automatically run queries that write or delete data or metadata. It only runs queries that read data.
Re:Instant SQL for results as you type in DuckDB UI
by d0100 on Thursday April 24, 2025 @03:15PM
(#43786393)
And this is a happy coincidence that json_serialize_sql doesn't work with anything but select queries
Re:Instant SQL for results as you type in DuckDB UI
by crmi on Thursday April 24, 2025 @10:27AM
(#43783231)
Young bobby tables at it again
Re:Instant SQL for results as you type in DuckDB UI
by worldsayshi on Thursday April 24, 2025 @10:36AM
(#43783355)
Can't it just run inside a transaction that isn't committed?
Re:Instant SQL for results as you type in DuckDB UI
by ryguyrg on Thursday April 24, 2025 @10:13AM
(#43783070)
ROFL
Re:Instant SQL for results as you type in DuckDB UI
by codetrotter on Thursday April 24, 2025 @10:25AM
(#43783203)
ROFL FROM jokes WHERE thats_a_new_one;