A few suggestions and Issues

 
Formatting Ideas, Issues and Questions
Last Post by Guido 3 months ago
3 Posts
2 Users
0 Reactions
63 Views
 mythas
(@mythas)
Member
Joined: 3 months ago
Posts: 2
Topic starter 16/10/2024 10:43 pm  

Hi! Thanks for making this! So far its working really well. A few suggestions and issues:

 

SELECT TOP N doesn't format well. Its not recognized as a keyword and gets put on the first line of the select items. 

 

image
 
Having window functions spread over multiple lines can be overkill. Could we have a no linebreak on window function if under n characters option? Similar to whats available for case statements.
image
 
Aliases on case statements don't get aligned properly. 
 

image
 
I am using the VSCode extension
This topic was modified 3 months ago by mythas

   
Quote
 mythas
(@mythas)
Member
Joined: 3 months ago
Posts: 2
Topic starter 22/10/2024 11:46 pm  

It is also not handling square brackets around column names well. 

image

is being formatted as

image

the extra spaces in the [ ] breaks the query as those aren't the column names

 


   
ReplyQuote
Guido
 Guido
(@admin)
Member Admin
Joined: 3 years ago
Posts: 223
23/10/2024 7:33 am  

Hi @mythas,

thanks for your feedback. For the last post (square brackets), did you choose the correct DB (e.g. SQL Server)?

Regards

Guido


   
ReplyQuote
Forum Jump:
  Previous Topic
Next Topic  
Share: