als-model

als-model v0.8.27 provides an instrument for MySQL and SQLite database operations, including queries, migrations, and fake data generation. It offers a chaining API for building SQL statements (SELECT, WHERE, UPDATE, DELETE, INSERT) with promise or callback support. The library also includes a Migration tool for creating/dropping tables and a Types module for field type definitions. Released as a JavaScript package, it targets Node.js environments and does not bundle TypeScript types. Key differentiators include a simple object-based condition syntax supporting AND/OR logic, and a single Model class that works with both MySQL and SQLite.