hiddentao/squel

Health v2 · maintenance only

Flags: no_releases

Adoption not part of the score

1570 stars · 230 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

Squel is a lightweight SQL query string builder library for JavaScript and TypeScript with a fluent, method-chaining API. It generates standard SELECT/INSERT/UPDATE/DELETE statements plus dialect-aware features (CTEs, UPSERT, MERGE, RETURNING, window functions) for MySQL, PostgreSQL, SQLite, and MS SQL Server, running in both Node.js and the browser.

Use cases

• build sql queries in javascript without string concatenation
• sql query builder for node.js or typescript
• generate parameterized sql queries with safe value escaping
• build postgres upsert or mssql merge queries programmatically
• write cte and window function queries with a fluent js api
• construct sql statements dynamically at runtime in the browser
• avoid sql injection from brittle string substitution when assembling queries

When to choose

• You need to construct SQL query strings programmatically with a clean, fluent API but do not want a full ORM
• You want a tiny (~8 KB) dependency that works in both Node.js and the browser
• You need dialect-specific SQL features like Postgres UPSERT, SQL Server MERGE, RETURNING/OUTPUT clauses, or window functions
• You want a library you can extend with custom query blocks or commands

When to avoid

• You need to actually connect to and execute queries against a database - squel only builds SQL strings and ships no drivers
• You need full ORM capabilities such as migrations, schema management, or result mapping (consider Knex or a dedicated ORM)
• You intend to generate queries in the browser and execute them server-side, which is an unsafe pattern the project explicitly warns against

Facets

library · maturity active

database databases backend web-development developer-tools browser cross-platform sql query-builder query-string-builder typescript javascript mysql postgresql mssql sqlite fluent-api method-chaining parameterized-queries cte window-functions esm npm nodejs

Member repositories

For agents

markdown · JSON · MCP: product_card(name="hiddentao/squel")