LispWorks User Guide and Reference Manual > 19 Common SQL > 19.5 Symbolic SQL syntax > 19.5.1 The "[...]" Syntax

NextPrevUpTopContentsIndex

19.5.1.4 Enclosing literal SQL

Literal SQL statements can simply be enclosed in the square bracket syntax, as shown below.

["SELECT FOO, BAR FROM BAZ"]
-> #<SQL "SELECT FOO, BAR FROM BAZ">
[select [*] :from [tbl]]
-> #<SQL-QUERY "(SELECT * FROM TABLE)">
[person surname]
->#<SQL-IDENT "PERSON.SURNAME">
[> [foo] 37]
->#<SQL-RELATIONAL-EXP "(FOO > 37)">

LispWorks User Guide and Reference Manual - 22 Dec 2009

NextPrevUpTopContentsIndex