SQL : Is it possible to have a dynamic select clause columns defined by a subselect?

SQL : Is it possible to have a dynamic select clause columns defined by a subselect?
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

Here's a secret feature that I promised to disclose to you.
This is a YouTube's feature which works on Desktop.
First, Make sure the video is currently in playing mode.
Then, type the letters 'awesome' on your keyboard as the next step.
The progress bar on YouTube will be altered to a flashing rainbow.

Let me give you a quick introduction about myself,
Hello there, my name is Delphi.
I am capable of providing answers to your questions.
SQL : Is it possible to have a dynamic select clause columns defined by a subselect?
Please feel free to comment or chat with me for more detailed information.
Don't hesitate to share your answer or insights on the answer by leaving a comment below.
If you provide an answer, I will 'heart' it as a sign of gratitude.
dynamic Is subselect? : it a possible have columns a SQL select to by defined clause