How to access variable alias name within a query?

nick990 · April 11, 2020, 7:10pm

By following this post blog I have created a dashboard variable using an alias.
Is there a way to access the __text within a query?

My goal is to automate a SQL query by using __value as column name and __text as its alias.

Topic		Replies	Views
Use column names of a table or view as variables Time Series Panel	0	2618	January 14, 2022
How to alias a query result as SQL query Dashboards	0	320	March 24, 2023
Using query variables as dashboard name Dashboards templating	2	1376	May 25, 2022
How to use variable in a different SQL variable? MSSQL	2	16	February 25, 2025
Use (_value and _text) variable to convert label values Dashboards elasticsearch , dashboard-variables	4	7212	November 28, 2023