Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: Format SQL

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Allow item following AND/OR to be on new line

When formatting SQL, it would be good to have the option to put the item following an AND/OR on a new line and align it, so instead of:

WHERE
OutgoingResults.LoadDateKey = 20191106
AND OutgoingResults.FeedName = 'TestFeed'

we have

WHERE
OutgoingResults.LoadDateKey = 20191106
AND
OutgoingResults.FeedName = 'TestFeed'

14 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Gavin Beard shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Christoph Ebner von Eschenbach commented  ·   ·  Report

    Support this idea, but would prefer to have AND/OR leading on a new line (with correct intendation) - improves readability imo. Or better: make an option to have both variants.

  • Louis Somers commented  ·   ·  Report

    Also other options, For example, I prefer `ON` clauses to be aligned with the additional (AND / OR) conditions right aligned with `ON`.

    (Removed example since UserVoice removes all whitespace)

  • Steven Oates commented  ·   ·  Report

    Fantastic idea Gavin, I've been waiting for this for years. We also conform to a new line after each operator also with an indent however this formatting option isn't available in prompt.