Is there a constructor for complex SQL queries?

Question

MySQL

I am looking for software for a visual query builder, according to given criteria

. For example, to be able to build such a query:
Select the names of departments in Kiev (KYIV), with employees who got a job in the winter of 2017

DEPARTMENT
departament_id, name, location_id
LOCATION
location_id, name
EMPLOYEE
id, lname, fname, hire_date, manager_id

Answer 1

so dance from the database:
- built-in access
- for MS SQL - SSMS , VS + SSDT
- DevArt dbForge studios
- .. for the rest - so google to help .. builders are really crazy .. though "the rest" are often already paid. .. but in most cases it's enough to try, the pirate brothers help ))
ps https://www.jetbrains.com/datagrip/ again .. (although it's paid .. by the way .. JetBrains has all betas of all products - free ;) ))).. as well as cross-platform mostly .. well, https://www.jetbrains.com/toolbox/app/?fromMenu to help ;))) .. in the sense that to build a request and then try it on somewhere - I think the betas will be mostly quite suitable))

Answer 2

Navicat can build queries visually

Answer 3

Yes, I have. It's called the brain.
And all sorts of designers, I think the game is complete.
Yes, and the request from TS'a is simple, why constructors?

Answer 4

Better write yourself Sooner or later you will learn