SQL Query Formatter, Beautifier & Minifier

-- Unformatted Raw Query
select u.id,u.name,count(o.id) as total_orders,sum(o.total_amount) as revenue from users u left join orders o on u.id=o.user_id where u.created_at>='2026-01-01' and u.status='active' group by u.id,u.name having count(o.id)>5 order by revenue desc limit 10;

-- Formatted Production SQL
SELECT
  u.id,
  u.name,
  COUNT(o.id) AS total_orders,
  SUM(o.total_amount) AS revenue
FROM users u
LEFT JOIN orders o 
  ON u.id = o.user_id
WHERE
  u.created_at >= '2026-01-01'
  AND u.status = 'active'
GROUP BY
  u.id,
  u.name
HAVING
  COUNT(o.id) > 5
ORDER BY
  revenue DESC
LIMIT 10;

// Dialect-specific Identifier Quoting Rules
export function quoteIdentifier(name: string, dialect: 'postgres' | 'mysql' | 'tsql'): string {
  switch (dialect) {
    case 'mysql':
      return '`' + name.replace(/`/g, '``') + '`';
    case 'tsql':
      return '[' + name.replace(/\]/g, ']]') + ']';
    case 'postgres':
    default:
      return '"' + name.replace(/"/g, '""') + '"';
  }
}

// Basic SQL Tokenizer and Capitalizer in TypeScript
const SQL_KEYWORDS = [
  'SELECT', 'FROM', 'WHERE', 'AND', 'OR', 'LEFT JOIN', 'RIGHT JOIN',
  'INNER JOIN', 'OUTER JOIN', 'CROSS JOIN', 'ON', 'GROUP BY', 'HAVING',
  'ORDER BY', 'LIMIT', 'OFFSET', 'UNION', 'INSERT INTO', 'VALUES',
  'UPDATE', 'SET', 'DELETE FROM', 'WITH', 'AS', 'CASE', 'WHEN', 'THEN', 'ELSE', 'END'
];

export function formatSqlKeywordsUpper(sql: string): string {
  let result = sql;
  for (const kw of SQL_KEYWORDS) {
    const regex = new RegExp(`\\b${kw}\\b`, 'gi');
    result = result.replace(regex, kw);
  }
  return result;
}

WITH monthly_sales AS (
  SELECT
    DATE_TRUNC('month', order_date) AS sales_month,
    customer_id,
    SUM(total_price) AS monthly_spend
  FROM orders
  WHERE order_status = 'completed'
  GROUP BY 1, 2
),
ranked_customers AS (
  SELECT
    sales_month,
    customer_id,
    monthly_spend,
    RANK() OVER (PARTITION BY sales_month ORDER BY monthly_spend DESC) AS spend_rank
  FROM monthly_sales
)
SELECT
  sales_month,
  customer_id,
  monthly_spend
FROM ranked_customers
WHERE spend_rank <= 3
ORDER BY sales_month DESC, spend_rank ASC;

// Recommended: Parameterized Query in Node.js (pg)
import { Pool } from 'pg';
const pool = new Pool();

// ✅ Safe from SQL Injection
const query = 'SELECT id, email FROM users WHERE organization_id = $1 AND role = $2';
const values = [orgId, 'admin'];
const result = await pool.query(query, values);