Bringing Back Unnest
Joist uses the unnest function, and our own unnest_arrays function, for bulk updates.
Blog
Using CTEs and Query Rewriting for Versioning
Joist's plugin infrastructure allowed shipping a non-trivial versioning as a "cross-cutting concern" with a minimum amount of boilerplate.
Lazy Fields for 30x speedup without Decorators or Transforms
Joist leverages JavaScript's prototypes to blend great developer ergonomics/DX with performance.
Avoiding ORM Decorators
Entity-based ORMs, going back to Java's Hibernate & earlier, often use decorators or annotations like @PrimaryKey to define the domain model; Joist pushes back on this pattern, and prefers schema-driven code generation.
Pipelining for 3-6x Faster Commits
Pipelining INSERTs and UPDATEs statements to make commits 3-6x faster