PBI Oracle Error when trying to get SYSDATE

Hello fellow PBI users,

I try to create a subquery to use further down in my code:
WITH TODAY AS(
SELECT
TO_CHAR(SYSDATE, 'MM-DD-YYYY') "NOW"
FROM DUAL)

So, if you do SELECT * FROM TODAY, you should get a table with Col name "NOW" and value 12-07-2022 as characters (need that to parse in later subqueries)

However, I get this error: "Expression.SyntaxError: Token Comma expected."

The code runs fine in Toad.

As shown in PBI