SQL Code Formatting - JOINs on 1=1 on single line

Avatar
MattA
Created

I can't find a config option to have my code format to this type of style.   

 

All options result in this type of format , which is terrible when you're writing 1000s of lines of code.

 

Has anyone found a workaround for this? I tried importing my own XML file with my formatting but wasn't compatible with intelli Js format and I don't have time to figure out those restrictions..

 

Votes

0

Share

3 comments
Avatar
Anastasia Zhukova
Created

Hi,

Could you export your Code Style settings as shown below and share the XML file?

Also, what is your IDE version?

0
Avatar
MattA
Created

IDE version 2025.2.2

Below is my code style settings exported

<code_scheme name="Project copy" version="173">
<option name="RIGHT_MARGIN" value="10"/>
<H2CodeStyleSettings version="7">
<option name="USE_GENERAL_STYLE" value="false"/>
<option name="KEYWORD_CASE" value="2"/>
<option name="IDENTIFIER_CASE" value="2"/>
<option name="TYPE_CASE" value="2"/>
<option name="CUSTOM_TYPE_CASE" value="2"/>
<option name="ALIAS_CASE" value="2"/>
<option name="BUILT_IN_CASE" value="2"/>
<option name="QUOTED_IDENTIFIER_CASE" value="2"/>
<option name="QUERY_SECTION_1ST_WORD_ALIGN" value="8"/>
<option name="QUERY_EL_LINE" value="101"/>
<option name="QUERY_EL_COMMA" value="1"/>
<option name="SUBQUERY_OPENING" value="1"/>
<option name="SUBQUERY_CONTENT" value="1"/>
<option name="SUBQUERY_CLOSING" value="1"/>
<option name="INSERT_INTO_NL" value="2"/>
<option name="INSERT_CONTENT" value="0"/>
<option name="INSERT_VALUES_EL_LINE" value="101"/>
<option name="INSERT_EL_WRAP" value="0"/>
<option name="INSERT_EL_COMMA" value="1"/>
<option name="SET_ALIGN_EQUAL_SIGN" value="false"/>
<option name="SELECT_EL_LINE" value="101"/>
<option name="SELECT_EL_WRAP" value="3"/>
<option name="SELECT_EL_COMMA" value="1"/>
<option name="SELECT_NEW_LINE_AFTER_ALL_DISTINCT" value="true"/>
<option name="SELECT_KEEP_N_ITEMS_IN_LINE" value="3"/>
<option name="SELECT_USE_AS_WORD" value="1"/>
<option name="SELECT_ALIGN_AS" value="false"/>
<option name="FROM_EL_LINE" value="101"/>
<option name="FROM_EL_WRAP" value="3"/>
<option name="FROM_EL_COMMA" value="1"/>
<option name="FROM_WRAP_ON" value="true"/>
<option name="FROM_ONLY_JOIN_INDENT" value="1"/>
<option name="FROM_PLACE_ON" value="10"/>
<option name="TABLE_OPENING" value="1"/>
<option name="TABLE_CONTENT" value="2"/>
<option name="TABLE_CLOSING" value="6"/>
<option name="TABLE_TYPES_ALIGN" value="false"/>
<option name="TABLE_DEFAULTS_ALIGN" value="false"/>
<option name="TABLE_NULLABILITIES_ALIGN" value="false"/>
<option name="TABLE_ALTER_INSTRUCTION_WRAP" value="2"/>
<option name="TABLE_ALTER_INSTRUCTION_INDENT" value="false"/>
<option name="CONSTRAINT_WRAP_1" value="false"/>
<option name="POST_OPT_WRAP_1" value="true"/>
<option name="POST_OPT_INDENT" value="false"/>
<option name="POST_OPT_ALIGN" value="false"/>
<option name="VIEW_WRAP_AS" value="true"/>
<option name="VIEW_INDENT_QUERY" value="true"/>
<option name="CORTEGE_SPACE_BEFORE_COMMA" value="true"/>
<option name="CORTEGE_SPACE_AFTER_COMMA" value="false"/>
<option name="EXPR_CASE_WHEN_WRAP" value="false"/>
<option name="EXPR_CASE_END" value="9"/>
</H2CodeStyleSettings>
<MSSQLCodeStyleSettings version="7">
<option name="USE_GENERAL_STYLE" value="false"/>
<option name="KEYWORD_CASE" value="2"/>
<option name="IDENTIFIER_CASE" value="2"/>
<option name="TYPE_CASE" value="2"/>
<option name="CUSTOM_TYPE_CASE" value="2"/>
<option name="ALIAS_CASE" value="2"/>
<option name="BUILT_IN_CASE" value="2"/>
<option name="QUOTED_IDENTIFIER_CASE" value="2"/>
<option name="QUERY_SECTION_1ST_WORD_ALIGN" value="8"/>
<option name="QUERY_EL_LINE" value="101"/>
<option name="QUERY_EL_COMMA" value="1"/>
<option name="SUBQUERY_OPENING" value="1"/>
<option name="SUBQUERY_CONTENT" value="1"/>
<option name="SUBQUERY_CLOSING" value="1"/>
<option name="INSERT_INTO_NL" value="2"/>
<option name="INSERT_CONTENT" value="0"/>
<option name="INSERT_VALUES_EL_LINE" value="101"/>
<option name="INSERT_EL_WRAP" value="0"/>
<option name="INSERT_EL_COMMA" value="1"/>
<option name="SET_ALIGN_EQUAL_SIGN" value="false"/>
<option name="SELECT_EL_LINE" value="101"/>
<option name="SELECT_EL_WRAP" value="3"/>
<option name="SELECT_EL_COMMA" value="1"/>
<option name="SELECT_NEW_LINE_AFTER_ALL_DISTINCT" value="true"/>
<option name="SELECT_KEEP_N_ITEMS_IN_LINE" value="3"/>
<option name="SELECT_USE_AS_WORD" value="1"/>
<option name="SELECT_ALIGN_AS" value="false"/>
<option name="FROM_EL_LINE" value="101"/>
<option name="FROM_EL_WRAP" value="3"/>
<option name="FROM_EL_COMMA" value="1"/>
<option name="FROM_WRAP_ON" value="true"/>
<option name="FROM_ONLY_JOIN_INDENT" value="1"/>
<option name="FROM_PLACE_ON" value="10"/>
<option name="TABLE_OPENING" value="1"/>
<option name="TABLE_CONTENT" value="2"/>
<option name="TABLE_CLOSING" value="6"/>
<option name="TABLE_TYPES_ALIGN" value="false"/>
<option name="TABLE_DEFAULTS_ALIGN" value="false"/>
<option name="TABLE_NULLABILITIES_ALIGN" value="false"/>
<option name="TABLE_ALTER_INSTRUCTION_WRAP" value="2"/>
<option name="TABLE_ALTER_INSTRUCTION_INDENT" value="false"/>
<option name="CONSTRAINT_WRAP_1" value="false"/>
<option name="POST_OPT_WRAP_1" value="true"/>
<option name="POST_OPT_INDENT" value="false"/>
<option name="POST_OPT_ALIGN" value="false"/>
<option name="VIEW_WRAP_AS" value="true"/>
<option name="VIEW_INDENT_QUERY" value="true"/>
<option name="IMP_LOOP_LOOP_WRAP" value="false"/>
<option name="IMP_LOOP_LOOP_INDENT" value="false"/>
<option name="CORTEGE_SPACE_BEFORE_COMMA" value="true"/>
<option name="CORTEGE_SPACE_AFTER_COMMA" value="false"/>
<option name="EXPR_CASE_WHEN_WRAP" value="false"/>
<option name="EXPR_CASE_END" value="9"/>
</MSSQLCodeStyleSettings>
<MySQLCodeStyleSettings version="7">
<option name="USE_GENERAL_STYLE" value="false"/>
<option name="KEYWORD_CASE" value="2"/>
<option name="IDENTIFIER_CASE" value="2"/>
<option name="TYPE_CASE" value="2"/>
<option name="CUSTOM_TYPE_CASE" value="2"/>
<option name="ALIAS_CASE" value="2"/>
<option name="BUILT_IN_CASE" value="2"/>
<option name="QUOTED_IDENTIFIER_CASE" value="2"/>
<option name="QUERY_SECTION_1ST_WORD_ALIGN" value="8"/>
<option name="QUERY_EL_LINE" value="101"/>
<option name="QUERY_EL_COMMA" value="1"/>
<option name="SUBQUERY_OPENING" value="1"/>
<option name="SUBQUERY_CONTENT" value="1"/>
<option name="SUBQUERY_CLOSING" value="1"/>
<option name="INSERT_INTO_NL" value="2"/>
<option name="INSERT_CONTENT" value="0"/>
<option name="INSERT_VALUES_EL_LINE" value="101"/>
<option name="INSERT_EL_WRAP" value="0"/>
<option name="INSERT_EL_COMMA" value="1"/>
<option name="SET_ALIGN_EQUAL_SIGN" value="false"/>
<option name="SELECT_EL_LINE" value="101"/>
<option name="SELECT_EL_WRAP" value="3"/>
<option name="SELECT_EL_COMMA" value="1"/>
<option name="SELECT_NEW_LINE_AFTER_ALL_DISTINCT" value="true"/>
<option name="SELECT_KEEP_N_ITEMS_IN_LINE" value="3"/>
<option name="SELECT_USE_AS_WORD" value="1"/>
<option name="SELECT_ALIGN_AS" value="false"/>
<option name="FROM_EL_LINE" value="101"/>
<option name="FROM_EL_WRAP" value="3"/>
<option name="FROM_EL_COMMA" value="1"/>
<option name="FROM_WRAP_ON" value="true"/>
<option name="FROM_ONLY_JOIN_INDENT" value="1"/>
<option name="FROM_PLACE_ON" value="10"/>
<option name="TABLE_OPENING" value="1"/>
<option name="TABLE_CONTENT" value="2"/>
<option name="TABLE_CLOSING" value="6"/>
<option name="TABLE_TYPES_ALIGN" value="false"/>
<option name="TABLE_DEFAULTS_ALIGN" value="false"/>
<option name="TABLE_NULLABILITIES_ALIGN" value="false"/>
<option name="TABLE_ALTER_INSTRUCTION_WRAP" value="2"/>
<option name="TABLE_ALTER_INSTRUCTION_INDENT" value="false"/>
<option name="CONSTRAINT_WRAP_1" value="false"/>
<option name="POST_OPT_WRAP_1" value="true"/>
<option name="POST_OPT_INDENT" value="false"/>
<option name="POST_OPT_ALIGN" value="false"/>
<option name="VIEW_WRAP_AS" value="true"/>
<option name="VIEW_INDENT_QUERY" value="true"/>
<option name="IMP_LOOP_LOOP_WRAP" value="false"/>
<option name="IMP_LOOP_LOOP_INDENT" value="false"/>
<option name="CORTEGE_SPACE_BEFORE_COMMA" value="true"/>
<option name="CORTEGE_SPACE_AFTER_COMMA" value="false"/>
<option name="EXPR_CASE_WHEN_WRAP" value="false"/>
<option name="EXPR_CASE_END" value="9"/>
</MySQLCodeStyleSettings>
<OracleCodeStyleSettings version="7">
<option name="USE_GENERAL_STYLE" value="false"/>
<option name="KEYWORD_CASE" value="2"/>
<option name="IDENTIFIER_CASE" value="2"/>
<option name="TYPE_CASE" value="2"/>
<option name="CUSTOM_TYPE_CASE" value="2"/>
<option name="ALIAS_CASE" value="2"/>
<option name="BUILT_IN_CASE" value="2"/>
<option name="QUOTED_IDENTIFIER_CASE" value="2"/>
<option name="QUERY_SECTION_1ST_WORD_ALIGN" value="8"/>
<option name="QUERY_EL_LINE" value="101"/>
<option name="QUERY_EL_COMMA" value="1"/>
<option name="SUBQUERY_OPENING" value="1"/>
<option name="SUBQUERY_CONTENT" value="1"/>
<option name="SUBQUERY_CLOSING" value="1"/>
<option name="INSERT_INTO_NL" value="2"/>
<option name="INSERT_CONTENT" value="0"/>
<option name="INSERT_VALUES_EL_LINE" value="101"/>
<option name="INSERT_EL_WRAP" value="0"/>
<option name="INSERT_EL_COMMA" value="1"/>
<option name="SET_ALIGN_EQUAL_SIGN" value="false"/>
<option name="SELECT_EL_LINE" value="101"/>
<option name="SELECT_EL_WRAP" value="3"/>
<option name="SELECT_EL_COMMA" value="1"/>
<option name="SELECT_NEW_LINE_AFTER_ALL_DISTINCT" value="true"/>
<option name="SELECT_KEEP_N_ITEMS_IN_LINE" value="3"/>
<option name="SELECT_USE_AS_WORD" value="1"/>
<option name="SELECT_ALIGN_AS" value="false"/>
<option name="FROM_EL_LINE" value="101"/>
<option name="FROM_EL_WRAP" value="3"/>
<option name="FROM_EL_COMMA" value="1"/>
<option name="FROM_WRAP_ON" value="true"/>
<option name="FROM_ONLY_JOIN_INDENT" value="1"/>
<option name="FROM_PLACE_ON" value="10"/>
<option name="TABLE_OPENING" value="1"/>
<option name="TABLE_CONTENT" value="2"/>
<option name="TABLE_CLOSING" value="6"/>
<option name="TABLE_TYPES_ALIGN" value="false"/>
<option name="TABLE_DEFAULTS_ALIGN" value="false"/>
<option name="TABLE_NULLABILITIES_ALIGN" value="false"/>
<option name="TABLE_ALTER_INSTRUCTION_WRAP" value="2"/>
<option name="TABLE_ALTER_INSTRUCTION_INDENT" value="false"/>
<option name="CONSTRAINT_WRAP_1" value="false"/>
<option name="POST_OPT_WRAP_1" value="true"/>
<option name="POST_OPT_INDENT" value="false"/>
<option name="POST_OPT_ALIGN" value="false"/>
<option name="VIEW_WRAP_AS" value="true"/>
<option name="VIEW_INDENT_QUERY" value="true"/>
<option name="IMP_LOOP_LOOP_WRAP" value="false"/>
<option name="IMP_LOOP_LOOP_INDENT" value="false"/>
<option name="CORTEGE_SPACE_BEFORE_COMMA" value="true"/>
<option name="CORTEGE_SPACE_AFTER_COMMA" value="false"/>
<option name="EXPR_CASE_WHEN_WRAP" value="false"/>
<option name="EXPR_CASE_END" value="9"/>
</OracleCodeStyleSettings>
<PostgresCodeStyleSettings version="7">
<option name="USE_GENERAL_STYLE" value="false"/>
<option name="KEYWORD_CASE" value="2"/>
<option name="IDENTIFIER_CASE" value="2"/>
<option name="TYPE_CASE" value="2"/>
<option name="CUSTOM_TYPE_CASE" value="2"/>
<option name="ALIAS_CASE" value="2"/>
<option name="BUILT_IN_CASE" value="2"/>
<option name="QUOTED_IDENTIFIER_CASE" value="2"/>
<option name="QUERY_SECTION_1ST_WORD_ALIGN" value="8"/>
<option name="QUERY_EL_LINE" value="101"/>
<option name="QUERY_EL_COMMA" value="1"/>
<option name="SUBQUERY_OPENING" value="1"/>
<option name="SUBQUERY_CONTENT" value="1"/>
<option name="SUBQUERY_CLOSING" value="1"/>
<option name="INSERT_INTO_NL" value="2"/>
<option name="INSERT_CONTENT" value="0"/>
<option name="INSERT_VALUES_EL_LINE" value="101"/>
<option name="INSERT_EL_WRAP" value="0"/>
<option name="INSERT_EL_COMMA" value="1"/>
<option name="SET_ALIGN_EQUAL_SIGN" value="false"/>
<option name="SELECT_EL_LINE" value="101"/>
<option name="SELECT_EL_WRAP" value="3"/>
<option name="SELECT_EL_COMMA" value="1"/>
<option name="SELECT_NEW_LINE_AFTER_ALL_DISTINCT" value="true"/>
<option name="SELECT_KEEP_N_ITEMS_IN_LINE" value="3"/>
<option name="SELECT_USE_AS_WORD" value="1"/>
<option name="SELECT_ALIGN_AS" value="false"/>
<option name="FROM_EL_LINE" value="101"/>
<option name="FROM_EL_WRAP" value="3"/>
<option name="FROM_EL_COMMA" value="1"/>
<option name="FROM_WRAP_ON" value="true"/>
<option name="FROM_ONLY_JOIN_INDENT" value="1"/>
<option name="FROM_PLACE_ON" value="10"/>
<option name="TABLE_OPENING" value="1"/>
<option name="TABLE_CONTENT" value="2"/>
<option name="TABLE_CLOSING" value="6"/>
<option name="TABLE_TYPES_ALIGN" value="false"/>
<option name="TABLE_DEFAULTS_ALIGN" value="false"/>
<option name="TABLE_NULLABILITIES_ALIGN" value="false"/>
<option name="TABLE_ALTER_INSTRUCTION_WRAP" value="2"/>
<option name="TABLE_ALTER_INSTRUCTION_INDENT" value="false"/>
<option name="CONSTRAINT_WRAP_1" value="false"/>
<option name="POST_OPT_WRAP_1" value="true"/>
<option name="POST_OPT_INDENT" value="false"/>
<option name="POST_OPT_ALIGN" value="false"/>
<option name="VIEW_WRAP_AS" value="true"/>
<option name="VIEW_INDENT_QUERY" value="true"/>
<option name="IMP_LOOP_LOOP_WRAP" value="false"/>
<option name="IMP_LOOP_LOOP_INDENT" value="false"/>
<option name="CORTEGE_SPACE_BEFORE_COMMA" value="true"/>
<option name="CORTEGE_SPACE_AFTER_COMMA" value="false"/>
<option name="EXPR_CASE_WHEN_WRAP" value="false"/>
<option name="EXPR_CASE_END" value="9"/>
</PostgresCodeStyleSettings>
<SqlCodeStyleSettings version="7">
<option name="KEYWORD_CASE" value="2"/>
<option name="IDENTIFIER_CASE" value="2"/>
<option name="TYPE_CASE" value="2"/>
<option name="CUSTOM_TYPE_CASE" value="2"/>
<option name="ALIAS_CASE" value="2"/>
<option name="BUILT_IN_CASE" value="2"/>
<option name="QUERY_SECTION_1ST_WORD_ALIGN" value="0"/>
<option name="QUERY_EL_COMMA" value="1"/>
<option name="QUERY_IN_ONE_STRING" value="0"/>
<option name="SUBQUERY_OPENING" value="1"/>
<option name="SUBQUERY_CONTENT" value="1"/>
<option name="SUBQUERY_CLOSING" value="6"/>
<option name="INSERT_INTO_NL" value="2"/>
<option name="INSERT_OPENING" value="0"/>
<option name="INSERT_CONTENT" value="0"/>
<option name="INSERT_CLOSING" value="0"/>
<option name="INSERT_TABLE_EL_LINE" value="1"/>
<option name="INSERT_VALUES_EL_LINE" value="0"/>
<option name="INSERT_EL_WRAP" value="2"/>
<option name="INSERT_EL_COMMA" value="1"/>
<option name="INSERT_SPACE_WITHIN_PARENTHESES" value="true"/>
<option name="INSERT_MATRIX_INCLUDING_HEADER" value="true"/>
<option name="INSERT_MATRIX_MIN_WIDENING_THRESHOLD" value="0"/>
<option name="INSERT_MATRIX_BREAK_THRESHOLD" value="0"/>
<option name="SET_EL_WRAP" value="0"/>
<option name="SET_ALIGN_EQUAL_SIGN" value="false"/>
<option name="WITH_EL_WRAP" value="0"/>
<option name="SELECT_EL_LINE" value="101"/>
<option name="SELECT_EL_WRAP" value="3"/>
<option name="SELECT_EL_COMMA" value="1"/>
<option name="SELECT_NEW_LINE_AFTER_ALL_DISTINCT" value="true"/>
<option name="SELECT_USE_AS_WORD" value="1"/>
<option name="SELECT_ALIGN_AS" value="false"/>
<option name="FROM_EL_LINE" value="1"/>
<option name="FROM_EL_WRAP" value="0"/>
<option name="FROM_EL_COMMA" value="1"/>
<option name="FROM_WRAP_JOIN_1" value="false"/>
<option name="FROM_WRAP_JOIN_2" value="false"/>
<option name="FROM_INDENT_JOIN" value="false"/>
<option name="FROM_PLACE_ON" value="10"/>
<option name="WHERE_EL_WRAP" value="0"/>
<option name="ORDER_EL_LINE" value="0"/>
<option name="ORDER_EL_WRAP" value="0"/>
<option name="TABLE_OPENING" value="1"/>
<option name="TABLE_CONTENT" value="2"/>
<option name="TABLE_CLOSING" value="6"/>
<option name="TABLE_TYPES_ALIGN" value="false"/>
<option name="TABLE_DEFAULTS_ALIGN" value="false"/>
<option name="TABLE_NULLABILITIES_ALIGN" value="false"/>
<option name="TABLE_ALTER_INSTRUCTION_WRAP" value="2"/>
<option name="TABLE_ALTER_INSTRUCTION_INDENT" value="false"/>
<option name="CONSTRAINT_WRAP_1" value="false"/>
<option name="POST_OPT_WRAP_1" value="true"/>
<option name="POST_OPT_INDENT" value="false"/>
<option name="POST_OPT_ALIGN" value="false"/>
<option name="VIEW_WRAP_AS" value="true"/>
<option name="VIEW_INDENT_QUERY" value="true"/>
<option name="ROUTINE_ARG_OPENING" value="0"/>
<option name="ROUTINE_ARG_WRAP" value="0"/>
<option name="IMP_IF_THEN_WRAP_ELSE" value="false"/>
<option name="IMP_IF_THEN_WRAP_INNER" value="false"/>
<option name="IMP_IF_THEN_COLLAPSE" value="false"/>
<option name="IMP_LOOP_LOOP_WRAP" value="false"/>
<option name="IMP_LOOP_LOOP_INDENT" value="false"/>
<option name="CORTEGE_SPACE_BEFORE_L_PAREN" value="false"/>
<option name="CORTEGE_COMMA_1ST" value="true"/>
<option name="CORTEGE_SPACE_AFTER_COMMA" value="false"/>
<option name="EXPR_BINARY_OP_ALIGN" value="false"/>
<option name="EXPR_CALL_SPACE_AFTER_COMMA" value="false"/>
<option name="EXPR_CASE_WHEN_WRAP" value="false"/>
<option name="EXPR_CASE_WHEN_INDENT" value="false"/>
<option name="EXPR_CASE_ELSE_ALIGN_THEN" value="true"/>
<option name="EXPR_CASE_END" value="1"/>
<option name="EXPR_CASE_COLLAPSE" value="false"/>
</SqlCodeStyleSettings>
<codeStyleSettings language="Markdown">
<indentOptions>
<option name="TAB_SIZE" value="8"/>
</indentOptions>
</codeStyleSettings>
<codeStyleSettings language="MySQL">
<option name="KEEP_LINE_BREAKS" value="false"/>
<indentOptions>
<option name="TAB_SIZE" value="8"/>
</indentOptions>
</codeStyleSettings>
<codeStyleSettings language="Oracle">
<option name="KEEP_LINE_BREAKS" value="false"/>
<indentOptions>
<option name="TAB_SIZE" value="8"/>
</indentOptions>
</codeStyleSettings>
<codeStyleSettings language="PostgreSQL">
<option name="KEEP_LINE_BREAKS" value="false"/>
<indentOptions>
<option name="TAB_SIZE" value="8"/>
</indentOptions>
</codeStyleSettings>
<codeStyleSettings language="SQL">
<option name="KEEP_LINE_BREAKS" value="false"/>
<option name="KEEP_FIRST_COLUMN_COMMENT" value="false"/>
<indentOptions>
<option name="TAB_SIZE" value="8"/>
</indentOptions>
</codeStyleSettings>
<codeStyleSettings language="SQL92">
<option name="KEEP_LINE_BREAKS" value="false"/>
<indentOptions>
<option name="TAB_SIZE" value="8"/>
</indentOptions>
</codeStyleSettings>
<codeStyleSettings language="TSQL">
<option name="KEEP_LINE_BREAKS" value="false"/>
<indentOptions>
<option name="TAB_SIZE" value="8"/>
</indentOptions>
</codeStyleSettings>
</code_scheme>
0
Avatar
Anastasia Zhukova
Created

The line break in ON T1.ID = T2.ID; appears because of the "Hard Wrap at: 10" setting in Editor > Code Style. You can increase this value to avoid it.

I also see you have a line break before the JOIN clause in your first screenshot. It's not currently possible to configure it, but you can track related feature requests here: DBE-2262 and DBE-23731. 

0

Please sign in to leave a comment.