kahveciderin/covara — reverse-engineered prompt

Build me a TypeScript toolkit called Covara that takes a Drizzle schema and turns it into a complete backend with almost no boilerplate. I want a table definition to become a full REST API automatically, with create, read, update, delete, filtering, search, pagination, relations, aggregates, batch actions, and generated API docs. It should also support live updates over SSE so connected clients stay in sync, including optimistic updates, offline queueing, reconnects, and a type safe client that works in React, React Native, and plain TypeScript.

It also needs the common backend stuff people usually rebuild every time, like auth and authorization scopes, sessions or JWT style login, password reset, social or OIDC login, file uploads, email flows, billing hooks, and background jobs. Make sure custom routes and business logic still fit cleanly into the system and trigger the same live updates and cache invalidation. It should run on regular Node servers and on Cloudflare Workers, with SQLite and Postgres support. Please include examples, tests, and decent docs, and look up current docs online if you need to.