Next: , Previous: , Up: Database   [Contents]

14.4 SSQL (experimental)

The concept of SSQL is very easy. Write SQL in s-expression.

Usage: 

(->sql sql-statement)
(where #:key val ... [literal string])
(having #:key val ... [literal string])
(/or conds ...)
(/and conds ...)

For example: 

(->sql select * from 'Persons (where #:city "Shenzhen"))
(->sql select '(age name) from 'Persons (where "age < 30"))

The SQL update maybe quite different to SQL grammar, it should like blow. 

(->sql update 'table set (list (list phone_number "13666666666")) (where #:name "john"))