# sqorn/sqorn

A Javascript library for building SQL queries

Repository: https://github.com/sqorn/sqorn
Canonical: https://ross.abutalabs.com/products/sqorn
Homepage: https://sqorn.org
Language: JavaScript
License: MIT
License Family: permissive
Topics: javascript, sql, query-builder, sql-query-builder, nodejs, tagged-template-literals, template-strings, postgres, postgresql
Archived: true
Last push: 2023-02-07T16:49:27+00:00

## Health v2 (maintenance only)
Score: 10/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 2965, "days_push": 1303, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, archived
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1860, forks 47 (observed 2026-08-28T04:05:45.337777+00:00)

## What it is
Sqorn is a lightweight JavaScript library for building SQL queries using tagged template literals, with a composable chain/extend/embed API. It generates parameterized queries safe from SQL injection and currently supports PostgreSQL only.

## Use cases
- build sql queries in javascript
- compose complex postgres queries from parts
- run parameterized crud queries in node
- lightweight alternative to knex for postgres
- write sql with tagged template literals

## When to choose
- you use PostgreSQL and want a fast, dependency-free query builder
- you prefer writing SQL-flavored queries over full ORM abstractions
- you need composable query fragments (chain, extend, embed)

## When to avoid
- you need databases other than PostgreSQL
- you want a full ORM with migrations and schema management
- you need a library under active development - it is in maintenance mode

## Facets
- artifact type: library
- maturity: maintenance
- function: database, orm, serialization
- domain: databases, backend, web-development, developer-tools
- platform: -
- tags: sql-query-builder, postgres, tagged-template-literals, parameterized-queries, crud, nodejs, javascript

## Member repositories
- sqorn/sqorn (main) score 10

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:45.337777+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:15:56.442312+00:00, confidence not recorded.
  - readme: https://github.com/sqorn/sqorn (fetched 2026-08-28T04:05:45.337777+00:00, sha bf10d967b26b)
  - registry_npm: https://registry.npmjs.org/sqorn (fetched 2026-08-29T10:55:53.983674+00:00, sha 9864d17781f1)
- Data as of 2026-08-30T08:39:29.467469+00:00.