Feature request in formatting of code

Hi,

Having just recently discovered the SQL Prompt for ADS, I was quick to play around with the extension as I've been looking for a formatter where almost everything could be configured to match our style in the team.
What we have come up with so far is almost perfect

I've added two examples (depending on your alias preference) on what we're trying to achieve (left the formatter, right the format we're trying to achieve)

Example1 https://imgur.com/qeqnUq8
Example2 https://imgur.com/z7mBUql

1. Alignment of Aliases, although it's listed under lists it's affecting all aliases even tables, would it be possible to not have it affect tables ?
2. IIF statements do not appear to be supported in the same way CASE WHEN is, we format those too in a similar matter as CASE WHEN.
3. Depending on the Alias position (if you do Column As Column1 or Column1 = Column) would it be possible to make an option for CASE and IIF to start with a line break and be indented below? 
4. For CASE WHEN an option to make the WHEN align to indented tabstop would be nice, a lot of us use tab and not spaces and different applications.
Tagged:

Answers

  • Hi there @RKristensen

    Thanks for reaching out to use regarding this.

    I'm looking into these examples, in the mean time do you mind just confirming what versions of SQL Prompt and ADS you are currently using?
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
  • Hi,
    I was on version 0.2.9, this morning I can see there is an update, I will install that now.
  • Hi @RKristensen

    Just to check, have you had a chance to install the latest versions of SQL Prompt and/or ADS?
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
  • Hi,
    Yes, I'm on the new version now, all my points from the original post are still valid on the new version.
  • Hi @RKristensen

    My apology for the delay in coming back to you on this.

    I am just double checking on a couple of the points you raised and will come back to you as soon as I can.
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
  • Dan_JDan_J Posts: 460 Silver 2
    Hi @RKristensen

    My apology for the delay in updating you on this.

    I have been liaising with our development team on this with a view to addresses the formatting you have highlighted/requested. Unfortunately, given current priorities and workload we are unable to work on this any further at this time.

    I appreciate it would be useful for you to see these formatting options available in SQL Prompt and so suggest logging a feature request on our SQL Prompt User Voice page: https://redgate.uservoice.com/forums/94413-sql-prompt. This way our development team will have visibility of it, and other customers can vote for it.
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
  • Hello Red Gate Code Forum! 👋

    I’d like to suggest a few feature requests for the Fluxus Script Executor to enhance its functionality and user experience even further. Fluxus has been an incredibly reliable tool for executing scripts on Roblox, and it continues to be a favorite among many users for its performance and stability. However, I believe there are a few improvements that could make it even more efficient:

    1️⃣ Improved Script Library Integration: A more streamlined way to browse and access popular scripts directly from the executor would be amazing!
    2️⃣ Enhanced Error Reporting: A feature that better pinpoints and provides suggestions for script errors would help users troubleshoot faster.
    3️⃣ Customizable Themes: Offering dark and light themes or custom UI options would allow users to personalize their experience.

    These features could help Fluxus grow and become even more user-friendly, keeping up with the needs of its community. If anyone else has ideas or has used Fluxus for a while, feel free to share your thoughts! 😊

    Thanks for considering this request, and for providing such an awesome tool! 🔧
    Learn more about Fluxus Script Executor here!

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file