Anyone know how to execute dynamic SQL in codewars' postgres server?

[ChairmanMawh]

Just curious, if I had an sql like:

SELECT 'SELECT 1 as "' || TO_CHAR(CURRENT_DATE(), 'FMDYDDMONYY') ||'"' as Q

Which today would produce a resultset like:

Q
-
SELECT 1 as "THU24AUG23"

How do I then immediately execute this dynamically generated SQL, to form the actual output?

i.e. How would I execute the original query it in the codewards SQL panel, such that the output was immediately this (today):

THU24AUG23
----------
1

And tomorrow the same original query output would be:

FRI25AUG23
----------
1

And so on?

i.e. If I write an SQL whose output is a single string containing a valid SQL, how do I execute the query inside that string and retrieve its output as the output of the challenge?