prettier-plugin-tsql weekly downloads statistics

prettier-plugin-tsql

Beta — covers the vast majority of T-SQL; a number of less-common statements (and rarer forms of some common ones) are kept as their original source text (see Pending implementation). Breaking changes possible before 1.0.

A Prettier plugin that formats T-SQL (SQL Server) using Microsoft's official Microsoft.SqlServer.TransactSql.ScriptDom parser — the same parser SQL Server itself uses. Supports SQL Server syntax up to and including SQL Server 2025 (via TSql180Parser).

Requires .NET 8+ Runtime to be installed on your machine (the SDK is not needed).

Features

Parses T-SQL via the official ScriptDom library (no hand-rolled grammar). Configurable keyword casing, layout density, and comma style. Preserves -- and /* */ comments — trailing, leading, inside procedure bodies, between parameters and AS — and never drops one. The test suite checks that formatting never changes what a statement means: every fixture's ScriptDom syntax tree must be the same before and after. Emits go batch separators where required and keeps a repeat count (GO 5); a script made only of comments is kept as written. Integrates with editor extensions that support Prettier (VS Code, etc.).

DML

• SELECT, INSERT, UPDATE, DELETE
• MERGE INTO … USING … ON … WHEN MATCHED/NOT MATCHED
• OUTPUT / OUTPUT INTO on INSERT, UPDATE, DELETE, and MERGE (including $action, inserted.*, deleted.*); MERGE … INSERT DEFAULT VALUES
• OPTION (…) query hints on SELECT, INSERT, UPDATE, DELETE, and MERGE, including the distributed-query hints FORCE DISTRIBUTED PLAN, FORCE SINGLE NODE PLAN and FOR TIMESTAMP AS OF '…'
• UPDATE / DELETE … WHERE CURRENT OF [GLOBAL] cursor
• CTEs, UNION/UNION ALL, subqueries, derived tables (with column lists: (SELECT …) AS s (a, b))
• SELECT … INTO new_table [ON filegroup]
• EXISTS / NOT EXISTS, GROUP BY / HAVING
• CASE expressions (simple and searched), IN/NOT IN (value lists and subqueries), ANY/ALL subquery predicates
• Inline VALUES(...) derived tables in FROM
• TOP (n), TOP (n) PERCENT, TOP (n) WITH TIES
• PIVOT / UNPIVOT
• FOR XML (AUTO, PATH, RAW, EXPLICIT, XMLSCHEMA, ELEMENTS, ROOT, TYPE, etc.) and FOR JSON (AUTO, PATH, ROOT, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER)
• TABLESAMPLE [SYSTEM] (n PERCENT|ROWS) [REPEATABLE(seed)]
• Temporal table queries — FOR SYSTEM_TIME AS OF, FROM … TO, BETWEEN … AND, CONTAINED IN, ALL
• Joins: INNER, LEFT, RIGHT, FULL OUTER, CROSS JOIN, CROSS APPLY, OUTER APPLY; multiple joins, multi-predicate ON, self-joins, parenthesized joins, derived table joins
• Table-valued functions (TVFs) in FROM clauses; table hints (WITH (NOLOCK), etc.)
• Window functions with OVER clause — PARTITION BY, ORDER BY, full frame support (ROWS/RANGE BETWEEN … AND …, UNBOUNDED PRECEDING/FOLLOWING, CURRENT ROW); IGNORE NULLS/RESPECT NULLS; named window references; named WINDOW clause
• Ordered set aggregates: WITHIN GROUP (ORDER BY …) for STRING_AGG, PERCENTILE_CONT/PERCENTILE_DISC, etc.
• COLLATE after any expression — columns, literals, variables, function calls, CAST, CASE, subqueries
• ODBC escapes: {fn UCASE(…)} function calls and {d '…'} / {ts '…'} literals
• Expression functions: CAST, CONVERT, TRY_CAST, TRY_CONVERT (with full data type including length/precision), IIF, COALESCE, NULLIF, AT TIME ZONE, IS [NOT] DISTINCT FROM, TRIM(LEADING|TRAILING|BOTH …), TRIM(chars FROM str), PARSE, TRY_PARSE
• Sequence expressions: NEXT VALUE FOR sequence [OVER (…)]
• JSON functions: JSON_OBJECT(key: value, …), JSON_ARRAY(…), JSON_ARRAYAGG(… ORDER BY …) with ABSENT|NULL ON NULL
• Full-text predicates: CONTAINS/FREETEXT (single column, multi-column, wildcard, LANGUAGE); CONTAINSTABLE/FREETEXTTABLE as join sources
• Rowset functions: OPENJSON and OPENXML with WITH schema declarations; OPENJSON row-path and AS JSON columns; OPENROWSET provider and OPENROWSET(BULK …) forms
• Built-in functions formatted as standard function calls: GREATEST, LEAST, DATE_BUCKET, DATETRUNC, GENERATE_SERIES, LEFT_SHIFT, RIGHT_SHIFT, BIT_COUNT, GET_BIT, SET_BIT, APPROX_PERCENTILE_CONT, APPROX_PERCENTILE_DISC, JSON_PATH_EXISTS, STRING_SPLIT, ISJSON, LTRIM, RTRIM

DDL…