SQLinForm SQL FormatterCommunity Discussion Forum
SQLinForm SQL Formatter
Would love an option to have 0 values on the first line SQL>SQL Lists > # Vals on Line 1 (effectively forcing a newline). This along with some other formatting options before/after will make custom formatting more extensible for keywords that are not actively supported right now.
Hi @nicholasd, thanks for your feedback. Which DB are you working with and could you please one example
Thanks
Guido
@Guido
I am working with Snowflake in Dbeaver. A simple example is below:
--------------------
-- CURRENT FORMAT --
--------------------
SELECT
-- Number of Values line 1 = 2
-- Number of Values line 2 = 2
CONCAT( 'String1', ', '
, 'STRING2', ', '
, 'STRING3', ', '
, 'STRING4'
)
----------------------
-- PREFERRED FORMAT --
----------------------
-- Number of Values line 1 = 0
-- Number of Values line 2 = 2
SELECT
CONCAT(
'String1', ', '
, 'STRING2', ', '
, 'STRING3', ', '
, 'STRING4'
)
OK, I will add an option for linebreaks before/after the bracket and to indent the values like in the screenshot for keyword1, keyword2 and keyword3
Hi @nicholasd,
it took some time but now your idea is available for N++ Plugin and Stand-Alone App
Regards
Guido
