For me, it’s CTE’s. I find it amazing to complete a calculation with clear intermediate steps, and goes a long way towards convincing people to use SQL rather than Excel to perform calculations on large tables of data.

What construct do you like using on a daily basis?

  • ddh@lemmy.sdf.org
    link
    fedilink
    arrow-up
    0
    ·
    1 year ago

    CTEs are so helpful for me. They make complex queries much easier to construct and lets me ‘unit test’ the parts I’m working on.

  • deegeese@sopuli.xyz
    link
    fedilink
    arrow-up
    0
    ·
    1 year ago

    Only thing cooler than CTEs are Recursive CTEs, but I struggle to find use cases where I can sneak one in.

    • luciole (he/him)@beehaw.org
      link
      fedilink
      arrow-up
      1
      ·
      1 year ago

      I believe recursive CTEs are pretty cool for tree traversal. Anytime you’ve got a table with a foreign key on its own primary key they might come in handy.