# rawsql-ts

> SQL-first lifecycle toolkit for testing, inspecting, and evolving database applications.

- **URL**: https://www.freshcrate.ai/projects/rawsql-ts
- **Author**: mk3008
- **Category**: Databases
- **Latest version**: `rawsql-ts@0.23.0` (2026-05-31)
- **License**: MIT
- **Source**: https://github.com/mk3008/rawsql-ts
- **Homepage**: https://mk3008.github.io/rawsql-ts/
- **Language**: TypeScript
- **GitHub**: 29 stars, 1 forks
- **Registry**: github
- **Tags**: `ast`, `code-generation`, `database-tooling`, `raw-sql`, `schema-evolution`, `sql`, `sql-first`, `sql-parser`, `typescript`

## Description

SQL-first lifecycle toolkit for testing, inspecting, and evolving database applications.

## Recent releases

| Version | Date | Urgency | Changes |
| --- | --- | --- | --- |
| `rawsql-ts@0.23.0` | 2026-05-31 | High | ### Minor Changes  - [#856](https://github.com/mk3008/rawsql-ts/pull/856) [`4698a87`](https://github.com/mk3008/rawsql-ts/commit/4698a87e9a73f8d6b87b0545cb0a740246f7d457) Thanks [@mk3008](https://github.com/mk3008)! - Add `identifierEscapeTarget: "minimal"` to `SqlFormatter` so identifier quotes are removed only when the bare identifier is syntactically valid and semantically safe. The escape symbol remains controlled separately by `identifierEscape` (`quote`, `backtick`, `bracket`, or explicit |
| `rawsql-ts@0.22.0` | 2026-05-29 | High | ### Minor Changes  - [#853](https://github.com/mk3008/rawsql-ts/pull/853) [`95cf764`](https://github.com/mk3008/rawsql-ts/commit/95cf764a6ed70ec158f594f023354bfc9bc81110) Thanks [@mk3008](https://github.com/mk3008)! - Add SSSQL rewrite plan APIs on `SSSQLFilterBuilder` so callers can inspect scaffold, refresh, and remove rewrites before applying them. Plans include rewritten SQL, edit spans, safety metadata, warnings, and errors. Scalar add and remove plans can now return minimal span-based edit |
| `@rawsql-ts/ztd-cli@0.27.2` | 2026-05-23 | High | ### Patch Changes  - [#848](https://github.com/mk3008/rawsql-ts/pull/848) [`ab62ac5`](https://github.com/mk3008/rawsql-ts/commit/ab62ac5b26cb14a10cc8905fceabcf2590fe4a27) Thanks [@mk3008](https://github.com/mk3008)! - Tighten the starter first-run experience by keeping the generated smoke QuerySpec typecheckable, wrapping aggregate Postgres connection failures with concise recovery steps, and extending publish artifact verification to run starter typecheck, DB-free smoke tests, and ztd-config be |
| `rawsql-ts@0.20.0` | 2026-04-21 | High | ### Minor Changes  - [#773](https://github.com/mk3008/rawsql-ts/pull/773) [`e9e425f`](https://github.com/mk3008/rawsql-ts/commit/e9e425f77b51402fcca03393305ac36bc99d7576) Thanks [@mk3008](https://github.com/mk3008)! - Improve SSSQL `refresh` so correlated `EXISTS` / `NOT EXISTS` branches can be safely re-anchored after query structure changes.    `rawsql-ts` now relocates correlated optional branches by inferring a single anchor from outer references, rebases aliases when moving branches across |
| `@rawsql-ts/ztd-cli@0.26.0` | 2026-04-21 | High | ### Minor Changes  - [#773](https://github.com/mk3008/rawsql-ts/pull/773) [`e9e425f`](https://github.com/mk3008/rawsql-ts/commit/e9e425f77b51402fcca03393305ac36bc99d7576) Thanks [@mk3008](https://github.com/mk3008)! - Improve SSSQL `refresh` so correlated `EXISTS` / `NOT EXISTS` branches can be safely re-anchored after query structure changes.    `rawsql-ts` now relocates correlated optional branches by inferring a single anchor from outer references, rebases aliases when moving branches across |
| `@rawsql-ts/testkit-sqlite@1.0.5` | 2026-04-21 | High | ### Patch Changes  - Updated dependencies [[`e9e425f`](https://github.com/mk3008/rawsql-ts/commit/e9e425f77b51402fcca03393305ac36bc99d7576), [`6a1cb41`](https://github.com/mk3008/rawsql-ts/commit/6a1cb415366f3b8c0650f1caac67d9235ed1a130)]:   - rawsql-ts@0.20.0   - @rawsql-ts/testkit-core@0.16.5 |
| `@rawsql-ts/testkit-postgres@0.15.7` | 2026-04-21 | High | ### Patch Changes  - Updated dependencies [[`e9e425f`](https://github.com/mk3008/rawsql-ts/commit/e9e425f77b51402fcca03393305ac36bc99d7576), [`6a1cb41`](https://github.com/mk3008/rawsql-ts/commit/6a1cb415366f3b8c0650f1caac67d9235ed1a130)]:   - rawsql-ts@0.20.0   - @rawsql-ts/testkit-core@0.16.5 |
| `@rawsql-ts/testkit-core@0.16.5` | 2026-04-21 | High | ### Patch Changes  - Updated dependencies [[`e9e425f`](https://github.com/mk3008/rawsql-ts/commit/e9e425f77b51402fcca03393305ac36bc99d7576), [`6a1cb41`](https://github.com/mk3008/rawsql-ts/commit/6a1cb415366f3b8c0650f1caac67d9235ed1a130)]:   - rawsql-ts@0.20.0 |
| `@rawsql-ts/sql-grep-core@0.1.9` | 2026-04-21 | High | ### Patch Changes  - Updated dependencies [[`e9e425f`](https://github.com/mk3008/rawsql-ts/commit/e9e425f77b51402fcca03393305ac36bc99d7576), [`6a1cb41`](https://github.com/mk3008/rawsql-ts/commit/6a1cb415366f3b8c0650f1caac67d9235ed1a130)]:   - rawsql-ts@0.20.0 |
| `@rawsql-ts/ddl-docs-cli@0.2.7` | 2026-04-21 | High | ### Patch Changes  - Updated dependencies [[`e9e425f`](https://github.com/mk3008/rawsql-ts/commit/e9e425f77b51402fcca03393305ac36bc99d7576), [`6a1cb41`](https://github.com/mk3008/rawsql-ts/commit/6a1cb415366f3b8c0650f1caac67d9235ed1a130)]:   - rawsql-ts@0.20.0 |

## Citation

- HTML: https://www.freshcrate.ai/projects/rawsql-ts
- Markdown: https://www.freshcrate.ai/projects/rawsql-ts.md
- Dependencies JSON: https://www.freshcrate.ai/api/projects/rawsql-ts/deps

_Generated by freshcrate.ai. Indexes github releases for AI-agent ecosystem packages._