Suggestion: Drag&Drop select, quote column name

Bernhard

Member
Hi,

in a data warehouse application, we use a some columns with mixed case and white spaces. If these tables/views are dragged to a SQL window, all columns are not quoted therefore the select statement doesn't work.
Would it be possible to have quoted column names, maybe as a additional option?

Example:
select "Target", "Substance Name" from my_data;

instead of
select target, substance name from my_data;

Thanks a lot,

Bernhard
 
Back
Top