The square bracket syntax for the SQL interface is heavily overloaded to provide the most intuitive behavior in all situations. There are three uses of square brackets:
Each of these uses is demonstrated below.
LispWorks User Guide and Reference Manual - 21 Dec 2011