search

dbeaver / cloudbeaver

Cloud Database Manager
https://dbeaver.com/
Apache License 2.0
3.52k stars 383 forks source link

Support for SQL formatting is expected！ #522

Closed frank-lam closed 2 years ago

frank-lam commented 3 years ago

Formatting with the SQL editor improves our experience, and double-clicking the table name automatically generates select statements. Hope the official can support~

kseniiaguzeeva commented 3 years ago

Thank you for the feature request. Could you please give me more details about generating of Select statement? Generation of SQL statements is already possible via the table context menu in the Navigator tree and the Metadata Editor. Does it cover your needs? Screenshot 2021-10-27 at 07 51 42

frank-lam commented 3 years ago

@kseniiaguzeeva

This is also a good experience, but the SQL formatting scenario should be one where there is a tool for direct formatting when we write long SQL. It should be a format buttion like run in the sql editor page. This can greatly improve the efficiency of our SQL analysis.

kseniiaguzeeva commented 3 years ago

Thank you for the details. Do you want to click on a table name which is written in the SQL Editor for select statement generation?

frank-lam commented 3 years ago

@kseniiaguzeeva

when I use many of web database, double click auto written in the SQL Editor, like Apache Druid, it better experience for us to analysis for SQL. Whether you double click or right click you can play with your own thinking space. With a lot of Web clients, CloudBeaver is really powerful and I like that.

kseniiaguzeeva commented 3 years ago

We will implement both features.
I've created another ticket for your request about opening a table from the SQL Editor. Most probably, it will not be a select statement, the table will be opened in the separate Metadata Editor.

frank-lam commented 3 years ago

@kseniiaguzeeva Cloudbeaver iterates very efficiently. Thumbs up. Will this feature be available in this month's version?

frank-lam commented 3 years ago

@kseniiaguzeeva In addition, whether the administrator can support configuring the default theme.Because dark themes are popular with many people, you have to re-select the dark theme color every time you open your browser and log in.

kseniiaguzeeva commented 3 years ago

We are going to add theme support via local config. This is the ticket for the issue.

kseniiaguzeeva commented 2 years ago

SQL Formatting is implemented in the latest release 21.2.4.