can't run CTEs in query console

Whenever I tried to run a query with CTEs (subqueries), PyCharm always run it in separate statements (even I selected the whole script to run)... Sample query:

```

WITH a AS (

SELECT *

FROM TABLE

)

SELECT COUNT(*)

FROM a;

```

and it always ran in two statements and of course both failed.

Is this not supported or is there a tool can help?

Any help would be appreciated, thanks!