falcor84 3 months ago

Maybe in the next version they could also implement support for DROP, with autocorrect for the nearest (not yet dropped) table name.

Reply View 8 replies
  • munk-a 3 months ago

    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!

    Reply View 1 reply
    • falcor84 3 months ago

      Wow, that's perhaps the most nefarious version of chaos engineering I had ever heard of. Kudos!

      Reply View 0 replies
  • clgeoio 3 months ago

    LLM powered queries that run in Agent mode so it can answer questions of your data before you know what to ask.

    Reply View 4 replies
    • XCSme 3 months ago

      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 ...

      Reply View 2 replies
      • ako 3 months ago

        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.

        Reply View 1 reply
        • XCSme 3 months ago

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

          Reply View 0 replies
  • krferriter 3 months ago

    DELETED 0 rows. Did you mean `where 1=1`? (click accept to re-run with new where clause)

    Reply View 0 replies
matsonj 3 months ago

for clarity: Instant SQL won't automatically run queries that write or delete data or metadata. It only runs queries that read data.

Reply View 1 reply
  • d0100 3 months ago

    And this is a happy coincidence that json_serialize_sql doesn't work with anything but select queries

    Reply View 0 replies
worldsayshi 3 months ago

Can't it just run inside a transaction that isn't committed?

Reply View 0 replies
crmi 3 months ago

Young bobby tables at it again

Reply View 0 replies