I'm encountering an issue with an error when applying the date filter in SQL. Surprisingly, when I use the same filter through the query builder, the error does not manifest. Upon closer inspection, I've identified that the filters are constructed differently in the two types of queries. The filter via the query builder generates a "data > filter" and "data < filter," whereas the SQL filter uses "between data1 and data2."
Since I'm working with cube.dev, it seems unable to execute the query with the "between" clause. Is there a way to align the query filter created via the query builder with the one generated through SQL, perhaps using "data > filter" and "data < filter" instead of "between"?
created by sql
created by query builder