{"library":"node-sql-2","type":"library","category":null,"description":"node-sql is a SQL query builder for Node.js that supports PostgreSQL, MySQL, Microsoft SQL Server, Oracle, and SQLite dialects. Current stable version is 0.80.1, maintained primarily by TokyoFarmer. It provides a fluent API to define tables and construct parameterized queries, making it composable and dialect-aware. Key differentiators include automatic parameterization, named queries, and a flexible join system. Unlike ORMs, it focuses purely on SQL generation without abstraction over database drivers. The package ships TypeScript type definitions.","language":"javascript","status":"active","version":"0.80.1","tags":["javascript","typescript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install node-sql-2","imports":["import sql from 'sql'","import sql from 'sql';\nconst user = sql.define({ name: 'user', columns: ['id', 'name'] })","import type { Query } from 'sql'"]},{"cmd":"yarn add node-sql-2","imports":[]},{"cmd":"pnpm add node-sql-2","imports":[]}],"homepage":"https://github.com/TokyoFarmer/node-sql-2","github":"git://github.com/TokyoFarmer/node-sql-2","docs":null,"changelog":null,"pypi":null,"npm":"node-sql-2","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}