rawsql-tsTypeScript-native SQL parser and transformer

High-performance SQL parsing and transformation — all starting from your existing SQL.

Get Started

View API Docs

Open Playground

Zero Dependency

Fully self-contained and lightweight. Works in Node.js and browsers without external packages.

High-performance SQL Parsing

3–8× faster than major SQL libraries while supporting complex PostgreSQL queries.

Transform Existing SQL

Parse raw SQL into AST, apply dynamic filters and structural transformations, then regenerate optimized queries.

Browser & Playground Ready

Run in the browser via CDN and experiment with live formatting and analysis tools.

Quick Start

Install the package and build your first dynamic query:

bash

npm install rawsql-ts

Your First Dynamic Query

typescript

import { DynamicQueryBuilder, SqlFormatter } from 'rawsql-ts';

const baseSql = 'SELECT id, name, email, created_at FROM users WHERE active = true';

const builder = new DynamicQueryBuilder();
const query = builder.buildQuery(baseSql, {
  filter: { status: 'premium', created_at: { '>': '2024-01-01' } },
  sort: { created_at: { desc: true }, name: { asc: true } },
  paging: { page: 2, pageSize: 10 }
});

const formatter = new SqlFormatter();
const { formattedSql, params } = formatter.format(query);

console.log(formattedSql);
console.log(params);