I believe that Sequelize utilizes node-mysql in the background? Not sure about this. If it is, I'm wondering if there is any way to use it. Sequelize starts to fall down when you want to do complex multi table queries. But there is no way to run hand rolled sql queries with it using parameterized queries, or escaping input. Node-Mysql does all that. So, it would be nice to be able to use Sequelize when it makes sense, and node-mysql when it makes sense, without having to set up a new connection.
After scanning the documentation for a few seconds, I found this:
sequelize.query("SELECT * FROM myTable").success(function(myTableRows) {
console.log(myTableRows)
})
Looks like not. We are actually moving away from Sequelize into Node-mysql, it just doesn't do enough. In particular, if you want multiple connections, you have to replicate your entire definitions file. We are sharding our database, and have a set up a fairly simple method using node-mysql. It's nice to be able to code SQL again.