sql_formatter icon indicating copy to clipboard operation
sql_formatter copied to clipboard

Format Query within Column List

Open kfordaccela opened this issue 3 years ago • 2 comments

Describe the bug

When formatting a query that has a query within the column list

To Reproduce

python .from sql_formatter.core import format_sql

print( format_sql( "SELECT Column1, Column2, (SELECT column3 from SubTable) Column 4 FROM TABLE" ) )

output: SELECT_column1, _______column2, _______(SELECT_column3 _FROM___subtable)_column4 FROM___table

Expected behavior

SELECT _____column1, _____column2, _____( __________SELECT _______________column3 __________FROM__subtable _____)_column4 FROM table

Screenshots

Sorry for "_" but the 'code' in the editor was dropping formatting.

kfordaccela avatar May 27 '21 16:05 kfordaccela