I use SQL for CDS to prepare Dataverse queries that I use to retrieve data for consumption in Power BI. The ability to use native SQL queries makes data retrieval much faster than the current native Dataverse connector using the TDS endpoint. However, the current native Dataverse connector for Power BI automatically pulls in the Dataverse field Display Name (in the model view frontend, not in Power Query), which greatly simplifies my report development.

Currently, I am manually renaming all the fields in my SQL queries, e.g. a SQL alias like account.name as 'Account Name', which works fine but can be quite time-consuming and repetitive. It would be AMAZING if it were possible for SQL for CDS to have an option that automatically pulls in the Dataverse field Display Names as the query field names and updates the SQL code with the necessary, e.g. ... as 'XYZ Display Name' for all entities in the query. If there were identical Display Names across different entities (e.g. fields named "Name"), it might be necessary to differentiate identical field names by following the Dynamics naming convention of Field Display Name (Entity Name) or something more else SQL-style.

I often develop queries in FetchXML and send them to CDS for SQL once I've gotten them mostly complete. FetchXML will show entity Display Names on the columns in the result view, which is very useful for developing queries, and I think having Display Names available for retrieval in SQL for CDS would similarly improve its usefulness for query development.