Here's a session from me working on a side project yesterday:
https://chat.openai.com/share/a6928c16-1c18-4c08-ae02-82538d...
The most impressive thing I think starts in the middle:
* I paste in some SQL tables and the golang structrues I wanted stuff to go into, and described in words what I wanted; and it generated a multi-level query with several joins, and then some post-processing in golang to put it into the form I'd asked for.
* I say, "if you do X, you can use slices instead of a map", and it rewrites the post-processing to use slices instead of a map
* I say, "Can you rewrite the query in goqu, using these constants?" and it does.
I didn't take a record of it, but a few months ago I was doing some data analysis, and I pasted in a quite complex SQL query I'd written a year earlier (the last time I was doing this analysis), and said "Can you modify it to group all rows less than 1% of the total into a single row labelled 'Other'?" And the resulting query worked out of the box.
It's basically like having a coding minion.
Once there's a better interface for accessing and modifying your local files / buffers, I'm sure it will become even more useful.
EDIT: Oh, and Monday I asked, "This query is super slow; can you think of a way to make it faster?" And it said, "Query looks fine; do you have indexes on X Y and Z columns of the various tables?" I said, "No; can you write me SQL to add those indexes?" Then ran the SQL to create indexes, and the query went from taking >10 minutes to taking 2 seconds.
(As you can tell, I'm neither a web dev nor a database dev...)
