SQL Formatter Options

Extract & Generate SQL

SQLinForm can work on SQL that is embedded in application source code: it extracts the statement from the surrounding string concatenation, formats it, and writes it back wrapped in the syntax of your programming language. These options define the string delimiter to look for and the code template to emit.

Extract SQL from Code

Used by the Extract SQL from Source Code command: SQLinForm strips the surrounding programming-language syntax, formats the SQL it finds, and can then re-wrap it using the settings below.

ID	Option	What it does	Default
ID021	FreeSQL Enclosing Character SRCE_IS_ENCLOSED_CHAR	The character that encloses the SQL string in your source code – a double quote in most languages. SQLinForm uses it to find where the embedded statement begins and ends.	`''`

ID021 tells SQLinForm which character encloses the SQL string in your source code.

Source code (ID021 = ")

sql.append("select dept_nbr, dept_name ");
sql.append("from dept where dept_zip = '64521'");

Extracted and formatted

select dept_nbr,
       dept_name
from   dept
where  dept_zip = '64521'

Generate SQL Code

Pre-Defined Programming Language

ID	Option	What it does	Default
ID001	FreeSpecify the Programming Language in which you want to incl... OUTPUT_LANGUAGE	The programming language of the generated output. SQLinForm wraps the formatted SQL in that language's string syntax, ready to paste back into your code. Pick `My Output Format` to define your own template below. Choices: `SQL`, `My Output Format`, `ASP StringBuilder`, `C# StringBuilder(1)`, `C# StringBuilder(2)`, `Concatenated SQL(1)`, `Concatenated SQL(2)`, `Java StringBuffer(1)`, `Java StringBuilder(1)`, `Java String(1)` ... (23 in total)	`SQL`
ID054	FreeSpecidy the Variable Name which should be used in the abov... MY_VARIABLENAME	The variable name used in the generated code.	`SQL`

ID001 = SQL

select dept_nbr,
       dept_name
from   dept

ID001 = C# StringBuilder(1), ID054 = sql

StringBuilder sql = new StringBuilder();
sql.Append("select dept_nbr, ");
sql.Append("       dept_name ");
sql.Append("from   dept ");

My Output Format - Settings

ID	Option	What it does	Default
ID161	FreeSpecify the first line of your code preceding the actual S... FIRSTLINEPREFIX	The first line emitted before the SQL – typically a variable declaration.	`StringBuilder sql = new StringBu...`
ID163	FreeSpecify the code envelopping your SQL on the left side BODYLINEPREFIX	The text placed to the left of every SQL line.	`sql.append(''`
ID164	FreeSpecify the code envelopping your SQL on the right side BODYLINESUFFIX	The text placed to the right of every SQL line.	`'');`
ID166	FreeSpecify the code envelopping your SQL on the right side fo... LASTLINESUFFIX	The text placed to the right of the last SQL line, where a statement is usually terminated differently from the lines before it.	`'');`
ID167	FreeLinebreak Before Last Line Suffix (ID166) LBB_LASTLINESUFFIX	Puts the last-line suffix on a line of its own.	`off`

The four template fields and the code they produce. Used when ID001 is set to "My Output Format".

-- ID161 first line prefix : StringBuilder sql = new StringBuilder();
-- ID163 body line prefix  : sql.append("
-- ID164 body line suffix  : ");
-- ID166 last line suffix  : ").toString();

StringBuilder sql = new StringBuilder();
sql.append("select dept_nbr, ");
sql.append("       dept_name ");
sql.append("from   dept ").toString();

Option IDs are identical across all SQLinForm editions (VS Code, JetBrains, SSMS, Notepad++, Online Formatter) and are the keys stored inside a profile file. Generated from properties.json 2026.8.21.0.