Orma

Orma is a JSON-based, statically typed query language for SQL databases that converts parsable, serializable, and type-safe JSON syntax into SQL strings. It supports MySQL, PostgreSQL, and SQLite, offering features like validation, multi-tenancy, database introspection, declarative foreign keys, nested queries and mutations, mixed operations, dynamic types, batching, and query planning. Version 1.0.282 is the current stable version, with frequent releases. Unlike other ORMs, Orma is pure JS with no code generation and allows use of your own database connector.