{"library":"sql-syntax","type":"library","category":null,"description":"SQLSyntax is a JavaScript/TypeScript library for composing SQL queries using tagged template literals, ported from ScalikeJDBC. Version 2.0.1 is the latest stable release. It provides a SQLSyntax class and sqls template tag that automatically escapes interpolated values and generates parameterized queries, preventing SQL injection for safe values. Key differentiators include the ability to merge SQLSyntax instances directly into queries, a custom toQuery function for adapting to different databases (default PostgreSQL), and a createUnsafely method for dynamic identifiers with explicit safety warnings. The library is ESM-only since v2.0.0 and requires Node.js >=18. It ships TypeScript types and is published on npm.","language":"javascript","status":"active","version":"2.0.1","tags":["javascript","typescript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install sql-syntax","imports":["import SQLSyntax from 'sql-syntax'","import { sqls } from 'sql-syntax'","import type { SQLSyntax } from 'sql-syntax'"]},{"cmd":"yarn add sql-syntax","imports":[]},{"cmd":"pnpm add sql-syntax","imports":[]}],"homepage":"https://github.com/t83714/SQLSyntax#readme","github":"https://github.com/t83714/SQLSyntax","docs":null,"changelog":null,"pypi":null,"npm":"sql-syntax","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}