Another Small Sql Formatter Issue (with "between")

[peterlaursen]

.. and it does not even help to add paranthesis's like

Code:

SELECT * FROM table1 WHERE (field1 BETWEEN 1 AND 2) AND (field2 > 3)

I am afraid this will be a tough one. The formatter does not know the meaning of SQL. It recognizes string patterns using regular expressions. But maybe some additional condition can be added to that reqex when keyword BETWEEN appears in the string (like first AND after BETWEEN has anohter meaning that what AND normally has).

[Author]

Posts