5 ms·

Interesting note about left join in the CTE being converted into an inner join. Didn't know that

• whoami4041 7mo ago
  Yeah, it's one of those things that is hard to catch unless you've been bit by it before and know to look for it. Analytics teams at scale are at a much higher risk of this sneaking in, which is where automatic blocking with Lexega is helpful. No one wants to have to explain to their leadership why their dashboards were wrong from such a subtle SQL bug months down the road.
  • mattdeboard 7mo ago
    Honestly this insight feels very actionable to me. I do more SQL reporting for biz analysis than i would like (i'm a dev not a biz analyst). I may take a crack at this tool next week.
    • whoami4041 7mo ago
      Would love to help out! Shoot me an email at trial@lexega.com for a 30-day free trial license.
    • whoami4041 7mo ago
      Looping back here - trial licenses can now be obtained instantly through the free trial form on the website with just an email. No outreach needed on your part. Here for support if you decide to try it.
      • mattdeboard 7mo ago
        Hey just saw this. I will probably take a look at this on Monday.