Show HN: SQL Formatter

Re:Show HN: SQL Formatter by thesh4d0w on Monday August 21, 2023 @07:41PM (#37216783)

The 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.

[ Parent | on HN ]

Re:Show HN: SQL Formatter by croes on Tuesday August 22, 2023 @12:32AM (#37218717)

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.

[ Parent | on HN ]

Re:Show HN: SQL Formatter by yencabulator on Friday August 25, 2023 @11:19AM (#37262694)

Shall we even discuss the weird SQL injection stuff there, with what looks like Python string formatting? Use bind parameters, people!

[ Parent | on HN ]