Long queries are formatted like this:
select comma seperated stuff from many join joins using(more stuff) where 0=0 and p.AKTIV and ITEMNR not in("LOGIST") and TDYEAR = 2022 and not(StandardCost2 < PIECEPRICE /*and PIECEPRICE < EXFACTORYPRICE*/)
If I reformat this heidisql collapses all the wheres into one long line. Is there a setting I'm missing?
(Btw it also uppercases all keywords despite the fact that I've switched this off in settings. In my specific DB all the field names are uppercase so I would prefer SQL not shouting at me. but that probably is a neverending discussion)