Prettier SQL

Formats SQL files using the prettier-sql library

Issues

Please report issues here: https://github.com/inferrinizzard/prettier-sql/issues

Use the FORMATTING template if it is an issue related the formatting of the SQL, otherwise, please use the VSCODE template for issues with running the VSCode Extension

Configuration

Prettier-SQL.SQLFlavourOverride: Uses custom SQL Flavour to format sql files. Use this if you are using the Microsoft PostgreSQL or MSSQL Extensions since they do not provide a new language ID for VSCode.

Prettier-SQL.ignoreTabSettings: Whether to ignore VSCode user/workspace settings for tabSize and insertSpaces

Prettier-SQL.tabSizeOverride: Overrides tabSize if Prettier-SQL.ignoreTabSettings is enabled

Prettier-SQL.insertSpacesOverride: Overrides insertSpaces if Prettier-SQL.ignoreTabSettings is enabled

Prettier-SQL.uppercaseKeywords: Whether to print keywords in ALL CAPS or lowercase

Prettier-SQL.keywordPosition: Switched between standard keyword positioning vs maintaining a central space column

Prettier-SQL.breakBeforeBooleanOperator: Whether to break before or after AND and OR

Prettier-SQL.aliasAS: Where to use AS in column or table aliases

Prettier-SQL.tabulateAlias: Whether to right-align aliases to the longest line in the SELECT clause

Prettier-SQL.commaPosition: Where to place commas for SELECT and GROUP BY clauses

Prettier-SQL.keywordNewline: Rule for when to break keyword clauses onto a newline

Prettier-SQL.openParenNewline: Whether to place (, Open Paren, CASE on newline when creating a new block

Prettier-SQL.closeParenNewline: Whether to place ), Close Paren, END on newline when closing a block

Prettier-SQL.lineWidth: Number of characters allowed in each line before breaking

Prettier-SQL.linesBetweenQueries: How many newlines to place between each query / statement

Prettier-SQL.denseOperators: Whether to strip whitespace around operators such as + or >=

Prettier-SQL.semicolonNewline: Whether to place semicolon on its own line or on previous line