I should have mentioned that I'm looking at this from a data analysts point of view so the use case is writing a query on the database directly to pull back a dataset.
Unfortunately is a power that analysts often abuse (cases with many condition in long queries), my suggestion is usually to try to put the case logic in a function. It can be maintained more easily, the query is shorter and less prone to errors
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Thanks for the tips.
I should have mentioned that I'm looking at this from a data analysts point of view so the use case is writing a query on the database directly to pull back a dataset.
Unfortunately is a power that analysts often abuse (cases with many condition in long queries), my suggestion is usually to try to put the case logic in a function. It can be maintained more easily, the query is shorter and less prone to errors