There are quite a few other methods for rarer SQL expressions such as selecting all columns from a table or using SQL array subscripts, but in the interest of time I won't go over those.
