newlispfanclub.alh.net

In my time of looking at different languages, one Scheme version had a SQL query generation package that I thought made working with SQL easier. For instance:

(sql:select '(a.name a.age b.date) '((as a person) (as b dobs)) '((= a.id b.id)))

I was thinking of making something similar in newLISP, but I am running into a problem with things like '((= a.id b.id)) ... I am not good with the quoting, unquoting, etc... yet. Maybe this project is beyond my skill, but how can I actually parse the (= a.id b.id) portion? or another example would be:

(sql:select '(a.name (count a.id)) ...)

the (count a.id) should obviously turn into COUNT(a.id) for SQL.

Thanks for any info.

Jeremy

This program: http://newlisp.org/index.cgi?page=S-expressions_to_XML is a good example how to translate LISP S-expressions into something else, like SQL in your case instaed of XML in the example.

Lutz