This is a really awesome library to generate typesafe sql queries right from the C++ source code. Example usage:

  auto res = db(select(foo.name, foo.hasFun)
                .from(foo)
                .where(foo.id > 17 and foo.name.like("%bar%")));

Just a few months ago I realized that you can hack CoffeeScript's syntax to embed DSLs directly. I wrote up a quick little proof-of-concept for SQL [0], HTML [1], and CSS [2]. Obviously the HTML one is inspired by the React syntax.

I've always hated how easy it is to push SQL bugs into production, since it's so often just a string literal stuck in your code. AFAIC you don't really need the typing help, you just need to know that you didn't forget a damn comma somewhere.

[0]: https://github.com/couchand/just-sql

[1]: https://github.com/couchand/just-html

[2]: https://github.com/couchand/just-css

A similar library for Scala: http://squeryl.org/

What has SQL done to deserve this?

Is there a java equivalent?