I don't know about embedding, but I've been happy with the Metabase UI for building these kinds of queries:
https://www.metabase.com/docs/latest/users-guide/custom-ques...
Thanks for this comment. I am working on something very close to this vision at https://boomadmin.com
The idea is to have an open source (but commercial use paid license) that people can self host and totally have it offline or have it hosted on cloud with a single click.
I quit my job last month to work on it fulltime to work on an MVP. If you’re interested please add your email for an early beta.
I would love your feedback.
Re:Show HN: Visual SQL
by hermitcrab on Wednesday March 11, 2020 @05:16PM
(#22550759)
If you want an offline, no code, visual data transformation tool, please check out our new product:
https://www.easydatatransform.com/
Thank you, I'll take a look!
Just want to clarify – it doesn't have to be no code. In fact, a bidirectional workflow where you can edit the query either by writing SQL or clicking buttons is ideal.
For offline I would recommend SQLeo[0]. It has been around for a long time but I have yet to find something more powerful when exploring a new database or visually constructing queries. You can also visualise queries not created using SQLeo. Don't be put off by the dated look and feel, you can change the look and feel using some startup parameters.
https://perspective.finos.org/ supports simple SQL-like operations, group by, filters and sort e.g.
Somewhat related: does anyone know of any good components/libraries that can be embedded in a web page to let users interactively build SQL queries of reasonable complexity? By that I mean something that not only lets you pick columns and filter and maybe group things, but also do joins on other tables as well.
Edit: just to clarify, it doesn't have to be be visual only. In fact, something that lets you edit a query interactively either by visual components or actual SQL code is perfect, especially if it's bidirectional so that edits in the code also show in the UI and vice versa.