Which drivers out there...
- have support for all or most features of MySQL;
- are actively maintained;
- are asynchronous and support pipes;
- can interface with Sphinx?
I've used a couple but this is my choice:
node-mysql https://github.com/felixge/node-mysql
Well maintained and documented. The author is a node.js contributor and one of the founders of transloadit, I believe. As well as the author of node-formidable.