falcor84 15 hours ago

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

  • munk-a 12 hours 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!

    • falcor84 11 hours ago

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

  • clgeoio 15 hours ago

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

    • XCSme 15 hours 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 ...

  • krferriter 14 hours ago

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

matsonj 14 hours ago

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

  • d0100 10 hours ago

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

worldsayshi 15 hours ago

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

crmi 15 hours ago

Young bobby tables at it again