News for hackers. Stuff that matters.
Re:Getting AI to write good SQL by ljm on Sunday May 18, 2025 @09:22AM (#44021252)

    SELECT email FROM users WHERE deleted_at IS NOT NULL OR status = 'active'
seems more semantic to me at first glance than piping this into a JSON->SQL library

    {
      "_select": "email",
      "_table": "users",
      "_where": { 
        "deleted_at": { "_is": { "_not": SQL_NULL_VALUE } },
        "_or": [
          { "status": "inactive" },
        ]
      }
    }
which is usually how these things end up looking.

There are no comments on this comment yet.