An arbitrary function can be included in the SQL using the pseudo operator
sql-function
. The first argument is the function name and the rest are its arguments, for example:
(select [sql-function "COS" [age]] :from [EMPLOYEES])
(insert-records
:into [atable]
:attributes '(a b)
:values
(list 1 [sql-function "TO_DATE" "02/06/99" "mm/DD/RR"]))
Also you can call SQL infix operators using the pseudo operators
sql-boolean-operator
and
sql-operator
.