Viewing profile — regexman1

Brilliant

I'm an analyst so I literally only query for analytical purposes. I don't have any SQL code embedded in an application so the 1=1 is purely for tweaking/testing a query more quickl…

I've amended the README.md to explain what I meant. My error was in using the word dynamic!

Just to be clear I'm using it for the same reason as trailing commas. If I'm inspecting a dataset I use WHERE 1=1 so I can add and remove conditions more easily. I realise the conf…

That's right - it's just a quicker way of being able to comment/uncomment conditions when doing EDA or debugging.

Not at all actually, I just hadn't really planned to add this as a tip. Additionally I thought an in-line view was fine for the examples included. But maybe I will!

Fair point!

I appreciate the feedback, no offence taken. I'm an analyst so I often find the leading comma useful when I'm testing something and want to quickly comment a column out but I take …

That's a totally valid point haha.

I didn't realise that, great to know. Thanks!

I'll add this as a caveat. I'm an analyst so my SQL isn't really exposed to anyone other than myself and so I wasn't aware of this, thanks for flagging.