Dbeaver: Visual Query Builder

[osrojas]

Hi,

Can you implement a visual query builder in DBeaver? This is the only huge feature missing that others like Aqua Data Studio, DBVisualizer, etc. have that DBeaver doesn't. Would this be difficult to implement?

[serge-rider]

Good feature. But yes, quite difficult to implement.

[osrojas]

Is it possible to have this planned for the next major release?

[GiantCrocodile]

Is this really necessary? I thought about this too but then I thought of moments when I ever used a query builder ... it was like never. It just made stuff even more complicated to me. Although, if you think this is needed - I don't want to prevent you from suggesting it :).

[serge-rider]

Definitely not in 4.1. But maybe in 4.2

[osrojas]

I am requesting this feature on behalf of my company where there are several departments who utilize this feature extensively and is the only reason Aqua Data Studio is the preferred choice. It'd be great if you can get something like this in a 4.2 release. :)

[TesseractE]

I work with osrojas, and I'd like to address GiantCrocodile's comment... I rarely use the ADS Query Builder myself, but that's because I'm comfortable writing directly in SQL. We're trying to ease some not-so-SQL-savvy users into making their own direct requests though, and ADS's Query Builder has been really helpful in driving that adoption. Right now, that lack of accessibility is the only major thing keeping us from fully embracing DBeaver.

[kimdobranski]

I would like this also. Sometimes we have build complicated joins and its much quicker visually.

[fraxen]

This is the only feature I miss from Dbeaver!
(Which is a great piece of software - thanks for all the hard work!)

[PedroSolintel]

+1 for this feature. I'd like to see it on DBeaver, too.

[skaos]

+1

[ShepTeck]

+1 for this feature. I am excited to see it. We are also needing to service a large amount of non SQL savy users to allow for direct query. We used to use a tool called Hyperion, but because it has gone away, DBeaver is our next great solution. Not to mention it is a great tool. For our group if we had this feature, we could immediately begin to rollout to a larger community.

[serge-rider]

We have started to work on it. But most likely we won't do this till version 5.1 (release in June).

[johnlmiller]

Is this still targeted for 5.1 release in June? I have a set of business users who need a replacement tool after losing their Toad licensing due to budget constraints.

[serge-rider]

Unfortunately we can't include this in 5.1. This is too raw.
Visual Query builder will be the main feature for the next major release (as it is requested by lots of people).
First implementations will be included in EA versions soon.

[n-osennij]

+1

[dmcveay]

Definite +1 on this needed attribute. We recommend DBeaver to all of our 3rd party access customers and many are not confident writing queries directly and on joins and unions etc and this would be a win for them. Personal Note- all of the employee's in the group i work with use DBeaver 10+ hours a day and having this would make DB much better than the competition , hands down

[tati-kru]

Visual Query Builder is available for test as a part of early access version of the DBeaver EE. You can find it here: https://dbeaver.com/files/ea/. We are open for your feedback.

[n-osennij]

@tati-kru I add to tables and try to add condition. Open tab Conditions -> Add Column\Expression. By default operation is =. If I try to change it - no reaction. If try to change to in - get error (Operator IN is not supported). Manualy edit sql code I can't. If I turn off Query Builder mode generated code do not pasted into sql editor (if I not execute sql). So no any option to edit query by hands.

[tati-kru]

@n-osennij If you run script created in VQB it will be saved and you will be able to switch to the regular SQL editor and edit query manually. But you are right, it's a point for discussion: save or not the edited script when you are switching between SQL editor and VQB.
Regarding conditions we have just a very base functions now. It will be upgraded and improved further. Thank you for your feedback.

[dmcveay]

thank you so much

On Thu, Jul 26, 2018, 08:13 Tati Kru [e-mail] wrote:

Visual Query Builder is available for test as a part of early access
version of the DBeaver EE. You can find it here:
https://dbeaver.com/files/ea/. We are open for your feedback.

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
https://github.com/dbeaver/dbeaver/issues/1652#issuecomment-408092565,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AYbmnpUqQzTJzWj2_EvBxL_W7inomdLwks5uKcBfgaJpZM4NW8f5
.

[dclong]

@tati-kru Is this feature for the enterprise version only?

[tati-kru]

@dclong yes, it is implemented as a part of DBeaver EE only

[serge-rider]

@n-osennij Also you can save query by CTRL+S. IN operator support will be added in the next beta.
@tati-kru I think we'll add save function on query builder presentation switch in the next EA version.

[esequiel-ferreira]

Too bad that this feature will only be available in the paid version.

-1

[serge-rider]

Basically initial version of query builder is ready. It will require more improvements in future but even now it looks good enough. Please create separate tickets for improvements.
Till EE release it is in Early Access version.

[binaryPUNCH]

For people who suck at SQL like myself, it's such a great help to visually join tables together to get that semi-complicated query done. Looking forward to seeing this implemented into my new favorite database tool.

[GiantCrocodile]

Thanks for your wonderful work @serge-rider!

[codesmith55]

I hit Query Builder under the SQL Editor tab, it highlights, but nothing happens. I can open a new script editor and it's still text only. Your wiki says it should pop open and nothing else is clear for howto.

[tati-kru]

@codesmith55 unfortunately, it is not completely clear what do you mean. Visual Query Builder is available in DBeaver EE only. You can find a short demo how it works here: https://twitter.com/dbeaver_news/status/1116687401257140224