• ArtVandelay@lemmy.world
      link
      fedilink
      English
      arrow-up
      8
      ·
      3 months ago

      It doesn’t alter the query itself, it just makes maintaining larger and more complex queries easier. Without that statement in a dynamic query, you would have to dynamically add or remove the Where clause entirely in some situations, and this way you can keep it in and only add conditions as needed