Using a query result as title of a column

[salvador]

I'd like to use the data coming from a query as column name.
Suppose I have two tables:

Code: Select all   Expand viewCollapse view

my_table
┌──────┐
│ data │
├──────┤
│  1   │
│  2   │
│  3   │
└──────┘

my_second_table
┌─────────────┐
│ column_name │
├─────────────┤
│     foo     │
└─────────────┘

This is a pseudo-SQL query (giving a syntax error):

Code: Select all   Expand viewCollapse view

SELECT "data" AS ( SELECT "column_name" FROM "my_second_table" ) FROM "my_table"

The result I'd like to get is the value foo as header of the column:

Code: Select all   Expand viewCollapse view

╒═════╕
│ foo │
╞═════╡
│  1  │
│  2  │
│  3  │
└─────┘

How can I obtain this?
I'm using HSQLDB version 1.8.

[eremmel]

Is not possible. The column name is static and should be known at query parse time (the moment that the query is offered to the database engine).

[Villeroy]

On a form you can make a query result look like a column label.