Next: FPRM (experimental), Previous: ORM problem, Up: Database [Contents]
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"))