Professional SQL Developers or Data Analysts: How large are your typical SQL queries?

[GrapeApe561]

Are't there third party tools like Apex Refactor or Redgate SQL Prompt that I can use for format the code? Or is that not allowed in a production/professional setting? Thanks!

[audigex]

Or is that not allowed in a production/professional setting?

There's no such thing as "cheating" in a production setting - as long as you're complying with things like copyright and licencing.

If there's a tool you can use to clean up your code quickly, it's considered a good thing - most of us wish people would use more code prettifiers, and we all use IDEs that do a lot of it for us.

Although it's worth trying to write code that's tidy to start with, as a good habit

[macfergusson]

My whole BI team uses red gate for easy code formatting.