• curiousaur@reddthat.com
      link
      fedilink
      arrow-up
      1
      arrow-down
      4
      ·
      8 months ago

      Seriously though, why are you writing your own SQL still? It’s the language LLMs are the most accurate at translating English into. Like, the most insane inline aggregation, nested transaction nonsense; it just does it for you if you describe what you want and it knows your schema.

      • AlexWIWA@lemmy.ml
        link
        fedilink
        English
        arrow-up
        5
        ·
        8 months ago

        It doesn’t know the schema nor can it due to the sensitivity of the data I work with. It’s also faster to write the SQL than to describe it to the LLM. Once you get used to it, SQL is easier than English.

        • curiousaur@reddthat.com
          link
          fedilink
          arrow-up
          1
          arrow-down
          2
          ·
          8 months ago

          You can keep it private. And if you think you’re better than it you haven’t tried it. You can name the statement, and it will figure out what you want.

      • xmunk@sh.itjust.works
        link
        fedilink
        arrow-up
        2
        ·
        8 months ago

        It depends on the SQL. Anything non-trivial is still much better to write by hand to keep the intent clear.