Hacker News Reader

MySQL only

Which is why I'm still using Oyako (https://github.com/briancarper/oyako)

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.

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.

Reply on news.ycombinator.com