search

dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
39.16k stars 3.38k forks source link

Enquote with double quotes column name on drag & drop (if required) #34659

Open ask9 opened 2 months ago

ask9 commented 2 months ago

Description

I drag & drop column name. I expect it to be enquoted with double quotes automatically (because of uppercase and lowercase letters in the identifier), and do not equote - for lowercase letters in the identifier.

DBeaver Version

Community Edition 24.1.2

Operating System

Windows 10

Database and driver

PostgreSQL 16 PostgreSQL JDBC Driver 42.7.2

Steps to reproduce

https://github.com/dbeaver/dbeaver/assets/33929221/2cbb3eca-cebd-4056-8072-b9eb6e87ed55

Additional context

No response

E1izabeth commented 1 month ago

Thank you for requiest

ask9 commented 1 month ago

Another case for drag & drop to the filter textbox. Please also check all other draggable objects and their destinations.

select *
from (values(1,1),(1,2),(4,4)) as s("Quantity", "Value")

https://github.com/user-attachments/assets/693fca6c-ac0c-4a4c-a990-d2013b076e15

ask9 commented 2 days ago

Please also check that it works for all panels with result sets (for example, Grouping)