ClojureQL works fine with postgresql or any other database supported by JDBC.
Is there a way to tell it to use different syntax for take/drop for databases (like Sybase) that use the "select top X * from foo" syntax rather than "select * from foo limit X"?
Not yet. Currently we try to follow the SQL standard as closely as possible, but some operations like OFFSET/LIMIT provide challenges.
Would be fun to see if we could do some kind of SQL templating where users could supply their own templates.
Re:ClojureQL - 1.0.0 now in beta
by briancarper on Friday November 19, 2010 @01:29AM
(#1920645)
A new version of oyako is coming soon-ish (within a week or two) with possible mysql support, but it will always focus primarily on postgresql. The next version will also feature an SQL DSL similar to ClojureQL but less fancy / magical. (ClojureQL looks pretty cool itself though.)
In my brief experience, the idea of a cross-database SQL DSL is a lost cause unless you want to limit yourself to a very small subset of SQL. Funny, for a language that supposedly has a standard.
Which is why I'm still using Oyako (https://github.com/briancarper/oyako)