How to get a dynamic column name in a PostgreSQL SELECT statement

I have the following PostgreSQL table:

CREATE TABLE test (
  id INT,
  displaylabel VARCHAR(255)
);
INSERT INTO test (id, displaylabel) VALUES (1, 'Hello');
INSERT INTO INTO test (id, displaylabel) VALUES (2, 'World');

I want to write a SELECT statement that returns the number of rows in the table, with the column name being the current month and year. For example, if today is 2023-10-19, I want the result to be:

I tried the following SELECT statements, but they don’t work:

SELECT 
    id AS format('%s %s', to_char(current_date, 'Month'), to_char(current_date, 'YYYY')) 
FROM test;

SELECT id AS (
  to_char(CURRENT_DATE, 'Month') || ' ' || to_char(CURRENT_DATE, 'YYYY')
)
FROM test;

I get the following error messages:

Query Error: error: syntax error at or near "("

I need to use only SELECT statements because my account is read-only, so I can’t use EXECUTE.

How can I write a SELECT statement that returns the desired result, with a dynamic column name?

Example output:

DB fiddle : https://www.db-fiddle.com/f/9Hs1YtQxHfJMeKviNrj9Rb/0