Comment on Show HN: SQL FormatterComments−thesh4d0w3yThe example here is misformatted: frozen_rand BETWEEN % (rand_low) s AND % (rand_high) s Should all be on one line, those aren't two different conditions.−croes3yI guess it's newlining on certain key words like AND which is ok if it's a new where condition but unnecessary if it's part of an between clause.−yencabulator3yShall we even discuss the weird SQL injection stuff there, with what looks like Python string formatting? Use bind parameters, people!
Comments
The example here is misformatted:
Should all be on one line, those aren't two different conditions.I guess it's newlining on certain key words like AND which is ok if it's a new where condition but unnecessary if it's part of an between clause.
Shall we even discuss the weird SQL injection stuff there, with what looks like Python string formatting? Use bind parameters, people!