Sometimes, we don’t know how our SQL query will look like exactly as there are times that the query needs to be created dynamically.

Or, you may just be looking for a solution that will make SQL queries more readable.

Squel.js, a lightweight JavaScript library, helps building SQL query strings very easily through an object oriented API.

It works both on the browser (not advised as the queries will be visible to all) + with nodejs and supports all standard SQL queries (can be customized to support non-standard queries).

Telescope is an open source application for creating social news websites that has a similar functionality with Hacker News, Reddit, etc.

The application is built with Meteor, a real-time JS framework, and it runs on nodejs.

Every data in Telescope is displayed in real-time, it is possible to collect entries under categories and users can discuss on each entry easily.

Two types of authentication exist: e-mail/pass or Twitter and there is support for invite-only sign-up.

Layout provided by the app is responsive, has a very nice look and can be customized as well.

The-M-Project is an exciting HTML5 JavaScript framework for building cross-browser  mobile web applications (iOS, Android, Palm webOS, BlackBerry).

It makes use of jQuery on the JavaScript part and contains all ui + core files with features like offline support, internationalization and more.

The-M-Project is not alone, it requires nodeJS and comes with a build tool called: Espresso! which makes it easy to structure your code, build and run it on a built-in server.

Although the framework is in alpha stage, it is already well-documented and comes with multiple downloadable examples.