fix(sql): fix designated timestamp filter with now() function applied incorrectly in some cases (#2014)

Fix the bug resulting in queries of with designated timestamp filter with now() function

```
WHERE ts >= '2022-03-23T08:00:00.000000Z' AND ts < '2022-03-25T10:00:00.000000Z' AND ts > dateadd('d', -10, now())
```

could return different results depending of order of comparisons in WHERE