SQL Scripting is a feature that will soon be available in SmartList Builder and Navigation List Builder with the next release.  You will no longer have to go to SQL Management Studio and create a SQL View to pull into SmartList Builder when you want to write SQL Scripts to get the data you need.

The SQL Scripting option will show up as another table type to add to your setup.

Once you have selected the SQL Script option to add, it will open the Add SQL Script window where you can enter in the SQL Script you want to use.  You will also need to pick the key fields(s) from that script.

After entering the script, you can preview the data that is returned by it before saving the script if you like instead of having to save it and then view it in SmartList to see if it is what you are expecting.