sql-formatter-org/sql-formatter

View on GitHub

A whitespace formatter for different query languages

Stars: 2.9k
Forks: 456
Open beginner issues: 0
Indexed issues: 70
Avg merge: 3d 4h
Merged PRs (30d): 3

Dominant language: TypeScript
License: MIT
Last GitHub push: Sep 16, 2026
Latest indexed: Sep 20, 2026
Contributing guide: Contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed

Beginner friendly Everything

Open All

70 open issues indexed

Feature Request: Reduce issues with simple misconfigurations Open

feature

Difficulty 5/5 Over a week Newbie friendliness 35/100

sql-formatter-org/sql-formatter#951 · 4 comments · Opened May 22, 2026
Problem with unicode quotes in Transact-SQL Open

bug

Difficulty 3/5 1-2 days Newbie friendliness 54/100

sql-formatter-org/sql-formatter#942 · 1 comment · Opened May 1, 2026
Feature Request: Please add .commands support for DuckDB dialect Open

feature

Difficulty 3/5 1-2 days Newbie friendliness 48/100

sql-formatter-org/sql-formatter#939 · 2 comments · Opened Apr 10, 2026
[FORMATTING] Inconsistent formatting of PostgreSQL CREATE POLICY commands Open

bug

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sql-formatter-org/sql-formatter#928 · 3 comments · Opened Jan 20, 2026
treat `GO` as `;` if transactsql and split lines Open

feature

Difficulty 3/5 1-2 days Newbie friendliness 56/100

sql-formatter-org/sql-formatter#914 · 7 comments · Opened Oct 24, 2025
Feature Request: Support for sqlc Open

feature

Difficulty 3/5 1-2 days Newbie friendliness 42/100

sql-formatter-org/sql-formatter#913 · 1 comment · Opened Oct 21, 2025
missing -- sql comment support for disable formatting Open

Difficulty 3/5 1-2 days Newbie friendliness 48/100

sql-formatter-org/sql-formatter#912 · 1 comment · Opened Oct 21, 2025
Feature Request: --annotations & special characters format Open

feature

Difficulty 3/5 1-2 days Newbie friendliness 38/100

sql-formatter-org/sql-formatter#908 · 5 comments · Opened Oct 15, 2025
Avoid newlines for SET statements Open

bug postgresql

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sql-formatter-org/sql-formatter#901 · 5 comments · Opened Sep 9, 2025
spark ddl with struct data type error Open

bug spark

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sql-formatter-org/sql-formatter#900 · 3 comments · Opened Sep 9, 2025
In a window clause, "ROWS BETWEEN ..." should start a new line, it's not part of ORDER BY Open

bug

Difficulty 3/5 1-2 days Newbie friendliness 48/100

sql-formatter-org/sql-formatter#892 · Opened Aug 12, 2025
[FORMATTING] Line break at OUTPUT for SQL server Open

bug transactsql

Difficulty 3/5 1-2 days Newbie friendliness 48/100

sql-formatter-org/sql-formatter#888 · Opened Aug 4, 2025
Feature Request: SAP HANA SQL Dialect Support Open

feature new dialect

Difficulty 5/5 Over a week Newbie friendliness 25/100

sql-formatter-org/sql-formatter#886 · 1 comment · 1 reaction · Opened Jul 17, 2025
Feature Request: Support Pipe Syntax Formatting on DBx and BigQuery Open

bigquery feature

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#885 · 1 comment · Opened Jul 15, 2025
Feature Request: Add setting to wrap lines Open

feature

Difficulty 4/5 3-5 days Newbie friendliness 45/100

sql-formatter-org/sql-formatter#869 · 1 reaction · Opened May 27, 2025
TransactSQL `table WITH (NOLOCK)` is formatted as WITH-clause. Open

bug transactsql

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sql-formatter-org/sql-formatter#867 · 1 comment · 1 reaction · Opened May 22, 2025
In SELECT ... INTO, the INTO should be on a separate line Open

bug postgresql transactsql

Difficulty 3/5 1-2 days Newbie friendliness 55/100

sql-formatter-org/sql-formatter#864 · 3 comments · 1 reaction · Opened May 9, 2025
Feature Request: Format `jsonb_build_object` as `key, value` Open

feature postgresql

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#863 · 1 comment · 2 reactions · Opened May 9, 2025
Reserved words used as aliases cause a crash Open

bug db2 postgresql

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#801 · 1 comment · Opened Nov 14, 2024
Formatter doesn't recognize Hive CREATE TABLE modifiers Open

bug hive

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sql-formatter-org/sql-formatter#797 · 3 comments · Opened Nov 6, 2024
Feature Request: Line break before or after "+" Open

feature

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sql-formatter-org/sql-formatter#796 · 3 comments · Opened Nov 4, 2024
[FORMATTING] Formatter inserts space in between @ operator in mariadb dialect Open

bug mysql/mariadb

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

sql-formatter-org/sql-formatter#793 · 1 comment · Opened Oct 24, 2024
[FORMATTING] Formatter Adds Unwanted Space Before Dash and Number in Project Names (e.g., project -12345) Open

bigquery bug

Difficulty 3/5 1-2 days Newbie friendliness 48/100

sql-formatter-org/sql-formatter#791 · 3 comments · Opened Oct 22, 2024
Error formatting MariaDB CASE STATEMENT Open

bug mysql/mariadb

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sql-formatter-org/sql-formatter#780 · 4 comments · Opened Sep 16, 2024
Expose logs to VSCode frontend or describe in documentation how to reach the logs Open

feature vscode

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#774 · 4 comments · Opened Aug 31, 2024
db2i formatting does not work with JSON* functions Open

bug db2

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#773 · 1 comment · Opened Aug 30, 2024
Feature Request: Detect / Format parameters included in SQL statement Open

feature

Difficulty 5/5 Over a week Newbie friendliness 30/100

sql-formatter-org/sql-formatter#768 · 2 comments · Opened Aug 18, 2024
Feature Request: Detect dialect inside a comment or filename Open

feature

Difficulty 5/5 Over a week Newbie friendliness 30/100

sql-formatter-org/sql-formatter#764 · 1 comment · 3 reactions · Opened Aug 6, 2024
[FORMATTING] BigQuery: Doesn't handle escaped quotes in raw strings Open

bigquery bug

Difficulty 3/5 1-2 days Newbie friendliness 48/100

sql-formatter-org/sql-formatter#762 · 1 comment · Opened Jul 25, 2024
[FORMATTING] Missing space after colon in `JSON_OBJECT(key: value)` Open

bug postgresql

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sql-formatter-org/sql-formatter#761 · 1 comment · Opened Jul 23, 2024
[VSCode] Feature Request: Support JSON config file Open

feature

Difficulty 4/5 3-5 days Newbie friendliness 42/100

sql-formatter-org/sql-formatter#760 · 1 comment · 7 reactions · Opened Jul 21, 2024
Feature Request: Keep some blank lines when formatting Open

feature

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#750 · 1 comment · Opened Jun 20, 2024
Error when formatting Spark SQL Open

bug spark

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#746 · 5 comments · Opened Jun 12, 2024
[FORMATTING] Oracle pl/sql, assignment in case block Open

bug pl/sql

Difficulty 3/5 1-2 days Newbie friendliness 42/100

sql-formatter-org/sql-formatter#741 · 4 comments · Opened May 13, 2024
Some identifiers get converted to uppercase with keywordCase:upper Open

bug

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#740 · 3 comments · Opened May 9, 2024
Snowflake Unable to format SQL: Error: Parse error: Unexpected "@test;" at line 7 column 6 Open

bug snowflake

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#737 · 2 comments · Opened Apr 29, 2024
[FORMATTING] Unable to parse Hive syntax: STRUCT<x: INT64, y:STRING> Open

bug hive

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#735 · 3 comments · Opened Apr 23, 2024
Table name or alias "call" misinterpreted by formatter Open

bug postgresql

Difficulty 3/5 1-2 days Newbie friendliness 42/100

sql-formatter-org/sql-formatter#732 · 1 comment · Opened Apr 17, 2024
mysql: create procedure LOOP bug Open

bug mysql/mariadb

Difficulty 3/5 1-2 days Newbie friendliness 25/100

sql-formatter-org/sql-formatter#729 · 3 comments · 1 reaction · Opened Mar 23, 2024
[VS Code] Support for oracle_sql language files Open

feature

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

sql-formatter-org/sql-formatter#728 · 3 comments · Opened Mar 22, 2024
Feature Request: Databricks SQL Support Open

feature new dialect

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#727 · 2 comments · Opened Mar 20, 2024
PL/SQL error parsing FOR x IN a..b LOOP Open

bug pl/sql

Difficulty 4/5 3-5 days Newbie friendliness 30/100

sql-formatter-org/sql-formatter#722 · 3 comments · 1 reaction · Opened Mar 7, 2024
Feature Request: Option to Configure Indentation for SQL JOIN Clauses Open

feature

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#716 · 2 comments · 2 reactions · Opened Feb 9, 2024
[FORMATTING] Missing indent level of comment after CASE Open

bug

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#698 · 1 comment · Opened Jan 7, 2024
[FORMATTING] Parenthesized query starting directly after CTE Open

bug postgresql

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#687 · 2 comments · Opened Dec 5, 2023
Incorrect indentation in PostgreSQL `DELETE FROM ... USING` Open

bug postgresql

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#683 · 1 comment · 1 reaction · Opened Dec 4, 2023
Feature Request: SQL in SQL prettification Open

feature

Difficulty 5/5 Over a week Newbie friendliness 28/100

sql-formatter-org/sql-formatter#680 · 7 comments · 3 reactions · Opened Dec 1, 2023
[FORMATTING] comments after final WITH statement Open

bug

Difficulty 3/5 1-2 days Newbie friendliness 42/100

sql-formatter-org/sql-formatter#660 · 3 comments · Opened Nov 9, 2023
[FORMATTING] Space between type and options removed in nested BigQuery fields Open

bigquery bug

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sql-formatter-org/sql-formatter#619 · 1 comment · Opened Jul 10, 2023
Support Chinese parenthesis characters in MySQL Open

bug

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sql-formatter-org/sql-formatter#610 · 9 comments · Opened Jun 13, 2023

sql-formatter-org/sql-formatter

Get new issues in your inbox