sql-motif

A flexible SQL query fragment builder for Node.js that generates partial or full SQL queries. Current stable version is 0.5.6, released on an irregular cadence. It supports custom types, compound column expansion (e.g., addresses becoming multiple columns), and join/collation utilities. Unlike full ORMs, it focuses on composing fragments for tedious parts like field lists, leaving full query control to the developer. It includes validation and fill features for records, and supports PostgreSQL and MySQL dialects.