title: Node.js options for MySQL ORM
body: <p>I want to create a node.js and MySQL based application. Google and Stack Overflow give many options for Javascript ORMs:</p>
  
  <ul>
  <li><a href="http://sequelizejs.com/" rel="nofollow">sequelize.js</a></li>
  <li><a href="https://github.com/zefhemel/persistencejs/" rel="nofollow">persistence.js</a></li>
  <li><a href="https://npmjs.org/package/waterline/" rel="nofollow">waterline</a></li>
  <li><a href="http://knexjs.org/" rel="nofollow">knex.js</a></li>
  <li><a href="https://github.com/dresende/node-orm2/" rel="nofollow">node-orm2</a></li>
  <li><a href="http://bookshelfjs.org/" rel="nofollow">bookshelf.js</a></li>
  <li><a href="http://vincit.github.io/objection.js/" rel="nofollow">objection.js</a></li>
  </ul>
  
  <p>However, I could not find an perfect ORM that supports subqueries, joins, transitions, stored procedures, is compatible with MySQL cluster, and has good documentation and community support.</p>
  
  <p>Are there other options? What considerations should I take into account in making a decision?</p>