sql-wrap

sql-wrap is a lightweight Node.js library (v1.3.6-flow-fix-5) that wraps node-mysql with a promise-based API, supporting Q promises alongside callbacks. It provides convenient shorthand methods like select(), insert(), update(), upsert(), and delete() that automatically generate SQL from objects, and includes streaming support via queryStream() and selectStream(). Key differentiators: automatic pagination with config objects, nested table join support via nestTables, and replication-aware pool cluster support for read/write separation. The library emits a 'result' event on queries and exposes an interface similar to node-mysql. Last updated in 2019, it is in maintenance mode with no recent activity.