{"library":"sql-tagged-template-literal","type":"library","category":null,"description":"An ES6 tagged template literal for escaping SQL query values, returning a sanitized SQL string. v1.3.0 supports values as MySQL-compatible escaped strings, with special handling for null/undefined (unquoted NULL), numbers (unquoted), booleans (text), objects (JSON-stringified and escaped), arrays and Sets (comma-separated), and 2D arrays for multi-row inserts. Lightweight wrapper around the mysqljs/sqlstring library. Unlike alternatives, it outputs a plain string rather than a custom query object, thus suited for simple dumps or direct query execution. Not intended for table/column name escaping.","language":"javascript","status":"active","version":"1.3.0","tags":["javascript","sql","mysql","es6","tag","tagged","template","literal","string"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install sql-tagged-template-literal","imports":["import sql from 'sql-tagged-template-literal'","const sql = require('sql-tagged-template-literal')","import sql from 'sql-tagged-template-literal'"]},{"cmd":"yarn add sql-tagged-template-literal","imports":[]},{"cmd":"pnpm add sql-tagged-template-literal","imports":[]}],"homepage":"https://github.com/TehShrike/sql-tagged-template-literal#readme","github":"https://github.com/TehShrike/sql-tagged-template-literal","docs":null,"changelog":null,"pypi":null,"npm":"sql-tagged-template-literal","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}