There is not a separate User Guide document. There is an article that describes the features and briefly touches on usage (http://developer.teradata.com/tools/articles/terad
Yes, it is referred to as SQL Templates in Studio. Open a new SQL Editor for your connection profile. Enter CNTRL+SPACE. A pop up window appears with content assist options. Scroll down or start typing the SQL command to see the SQL template (example) you are looking for.
Has anyone tried the query band at the JDBC connection feature in 15.10 version ? It seems to work as is after installation. But once we change the query band value at the JDBC connection properties dialog box, the query band does not seem to show up when we run the 'help session' command