SQL Formatter Options

Options

Conditions

The Conditions Options in the SQL Formatter Tool allow you to configure how conditions in SQL statements are formatted. These settings control the placement of line breaks, indentation, and logical operator alignment, improving the readability and structure of SQL queries.

Sql Formatter Options Conditions

Brackets

  1. Before „(“ / After „(„

    • Before „(„: Adds a line break before the opening parenthesis in conditions.
    • After „(„: Adds a line break after the opening parenthesis.

  2. Before „)“ / After „)“

    • Before „)“: Adds a line break before the closing parenthesis in conditions.
    • After „)“: Adds a line break after the closing parenthesis.

  3. Indent Condition

    • Indents the conditions within brackets for better alignment and readability.

JOIN

  1. Before AND/OR / After AND/OR

    • Before AND/OR: Adds a line break before logical operators like AND or OR in JOIN conditions.
    • After AND/OR: Adds a line break after these logical operators.

  2. Indent AND/OR

    • Indents logical operators (AND/OR) in JOIN conditions to align them with the structure of the query.

WHERE

  1. Before AND/OR / After AND/OR

    • Before AND/OR: Adds a line break before logical operators in the WHERE clause.
    • After AND/OR: Adds a line break after these operators for better clarity.

  2. Indent AND/OR

    • Indents logical operators (AND/OR) in the WHERE clause for improved visual hierarchy.