DQL for tasks: fetching incorrect results

[RishiVora]

What I expected

I am trying to create a DQL query to fetch tasks that are:

1. due today
2. start today
3. start earlier than today

What is happening

But it also shows tasks that are overdue as well as the ones due in future.

I also tried splitting up the query into two.

still it does not work as intended.

DQL

1. single query

TASK
WHERE !completed AND (start <= date(today) OR due = date(today)) AND due != null AND contains(text, "#task")
GROUP BY file.link

2. the split up query

TASK
WHERE !completed AND due = date(today) AND due != null AND contains(text, "#task")
GROUP BY file.link

TASK
WHERE !completed AND start <= date(today) AND due != null AND contains(text, "#task")
GROUP BY file.link

JS

No response

Dataview Version

0.5.67

Obsidian Version

1.6.7

OS

Windows