SQL Prompt can run code analysis on your SQL as you type and warn you of any potential issues it finds. For some of the issues detected, SQL Prompt will highlight the error in the editor and enable you to automatically fix the issue using the light bulb in the sidebar.

The "...everywhere in file" option will run the auto-fix on every issue in the current file with one single click instead of having to do each one individually.