How to Create SmartList Builder Reports Based on SQL Views or Tables

Have you ever been working with a SmartList and needed to add just one more piece of information to make it complete, but when you look for it in the column chooser it is not there?