rawsql-ts

rawsql-ts enables fast parsing and formatting of SELECT queries, available on GitHub and npm, and works in browsers via CDN.

Input SQL

xxxxxxxxxx
 
SELECT
    id,
    name,
    email
FROM
    users
WHERE
    status = :active
ORDER BY
    created_at DESC;

Style Config

Style:

Name:

Style JSON:

xxxxxxxxxx
 
{
  "identifierEscape": {
    "start": "",
    "end": ""
  },
  "parameterSymbol": ":",
  "parameterStyle": "named",
  "indentSize": 4,
  "indentChar": " ",
  "newline": "\n",
  "keywordCase": "lower",
  "commaBreak": "before",
  "andBreak": "before"
}

Output SQL

xxxxxxxxxx
 
select
    id
    , name
    , email
from
    users
where
    status = :active
order by
    created_at desc

Table list

users

CTE list

(No CTEs found)

Schema

xxxxxxxxxx
 
[
  {
    "name": "users",
    "columns": [
      "email",
      "id",
      "name",
      "status"
    ]
  }
]

Analysis 2

ここに解析結果2が表示されるよ。

SQL formatted successfully.

CodeMirror is released under the MIT license. codemirror.net