sql-schema-generator

A declarative relational database SQL schema generator for PostgreSQL that abstracts boilerplate and enforces best practices like insert-only temporal database design, optimal data types, and naming conventions. Current stable version is 0.25.2, with an inactive release cadence (last release in 2020). It generates static and versioned tables, mapping tables, upsert functions, and current-version views to support event-driven, domain-driven design patterns. Unlike ORMs or migration tools, it produces raw SQL files under user control, avoiding lock-in and allowing custom modifications.