mysql-activerecord

A lightweight MySQL query builder for Node.js built on top of node-mysql. Version 0.8.6 is the latest stable release, with low release cadence and minimal maintenance. It provides a fluent API for building SELECT, INSERT, UPDATE, DELETE queries with automatic escaping and method chaining. Unlike full ORMs, it gives direct control over SQL while simplifying common patterns. It bundles node-mysql internally, so no extra dependencies are needed. Supports reconnection, raw queries, joins, grouping, and having clauses. However, it is limited to MySQL and ties closely to the callback-based node-mysql driver, lacking promise support.