SQL 格式化

按方言美化 SQL，或去掉注释与空白压缩成一行

方言

操作

关键字

缩进

SQL

SELECT
  u.id,
  u.name,
  count(o.id) AS orders,
  sum(o.total) AS spent
FROM
  users u
  LEFT JOIN orders o ON o.user_id = u.id
WHERE
  u.created_at >= '2026-01-01'
  AND u.status = 'active'
GROUP BY
  u.id,
  u.name
HAVING
  count(o.id) > 3
ORDER BY
  spent DESC
LIMIT
  20;

压缩会去掉注释并合并空白，字符串里的内容保持原样；格式化基于 sql-formatter，不同方言的关键字与函数识别略有差异。