Hi,
RefQL is celebrating its 5th anniversary!
It's a TypeScript library for writing type-safe relational queries.
After 5 years, it still doesn't have many users, but I've been using it myself in production for years without problems. So at least it has one happy customer.
The idea is to make relational queries easier to write and read, without losing type safety and IntelliSense.
For example, in some ORMs you have to write things like id: true and firstName: true just to select a few fields. I wanted to keep this a bit simpler.
With RefQL you can do:
const { Player, Team } = refql.tables.public; const readPlayers = Player([ "id", "firstName", Team(["name"]) ]); const players = await readPlayers();
The output type is inferred automatically, also for the referenced Team.
You can also use filters, sorting, pagination, inserts, updates, deletes and raw SQL.
For PostgreSQL, RefQL can introspect the database and generate the tables and references for you.
I've also added some comparisons with Drizzle,…