473,608 Members | 2,565 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Are Their Any Web Based Visual Drag and Drop SQL Builders Available (React, Vue, Angular, jQuery, .Net etc)?

1 New Member
I am looking for a visual SQL editor that we can embed into our web application. We would like an drag and drop interface similar to the ones in:
  • Microsoft SQL Server Management Studio
  • Microsoft Access Devart SQL
  • MySQL Workbench
  • SAP Crystal Reports
  • dbForce Query Builder

Ideally the tool can learn the database schema from the connected data source, allow the user to select tables, columns, create where clauses, create joins, apply functions, group, aggregate, sort, edit the SQL if needed, and hopefully preview the data. Once the user has saved the query the tool should be able to pass us back the SQL SELECT statement the user has created and optionally a JSON of the visual layout. We should be able to pass that SQL statement and/or JSON layout back to the tool so the user can edit the statement later on.

I have looked at ActiveQueryBuil der.com but I am looking for other options as well. At a minimum it needs to support SQLServer but ideally I would like it to support other database platforms as well like MySQL. We would like an open source library if one exists but are not apposed to using a commercial library. Ideally we would prefer a React or jQuery application but are open to other solutions as well such as .NET solutions. I have not found very many web based designers available. Please note the web application will run locally to the data source so ideally we need something that can be hosted locally and does not use a cloud service.

Thank you.
Mar 7 '22 #1
0 8070

Sign in to post your reply or Sign up for a free account.

Similar topics

5
2989
by: simon_s_li | last post by:
Hi, I have 5 fields in line where I need to drag and drop the text from one field to another field and then all the fields need to re-order themselves. So for instance if I drag the text in field 1 to field 3, then field 2 text and field 3 move to field 1 and field 2. I add the new order of text into an array so when the onDragEnd event
3
1911
by: simon_s_li | last post by:
Hi, I am having problems using drag drop and re-ordering items. Example: When I drag and item from position 1 and drag it to position 3, I want to re-order all the items accordingly. This means an item in position 1 is now is position 3 and item 2 is now in postion 1 and item 3 is in position 2 and position 4 and 5 stay the same. I have searched the web.
1
1901
by: Oleg Medyanik | last post by:
Hi, Is there any way to drag-drop messages from Outlook 2003 into my Application (.NET based) I have not found it googling yet. The problem is that i want the messages to preserve their MSG format, not just get their text. (it should look like you've dropped message to MS Word). Any help is appreciated. Thanks you
2
4319
by: SamSpade | last post by:
There seems to be two ways to put things on the clipboard ( I don't mean different formats): SetClipboardData and OleSetClipboard If I want to get data off the clipboard do I care how it was put there? What about Drag/Drop; is there more than one way for the source to make data available Is it always OLE?
4
2194
by: Qingdong Z. | last post by:
I have a VS.NET windows application which use drag-drop feather. It works fine when application start, but stops working after application run one or two days. The application is related to Video process, CPU/Memory extensive. The drag-drop is in a new windows form. It drags from TreeView Control to other control in the same form. It cannot trigger ItemDrag event of TreeView after drag-drop feather die. Can you give me any idea? Thanks.
5
10144
by: Brian Henry | last post by:
I haven't worked much with drag/drop but I am trying to make a form that accepts files to drug onto it from explorer and droped and have the form know the full path and file name of the files dropped onto it.. does anyone have any examples of this? thanks
1
1753
by: Alan T | last post by:
I have a tree view on the left and a list view on the right. I will drag and drop from list view to treeview, and also drag drop tree node on the same tree view. How do I differentiate I drag from listview or within the tree view when I drop on the tree view ?
0
1647
by: Mohit | last post by:
Hi, I have a win form having a web browser control on it. I want to have drag drop functionality on web browser control. My real need is - I should any how get the file name(s) along with path(s) whenever some file is dragged and dropped on my web browser control. I searched for it but there are drag drop events available with Web browser control as available with Rich text box etc. How can I achieve this functionality?
12
1582
by: lorlarz | last post by:
Unobtrusive JavaScript leads to BUILDERS (e.g. drag drop activity builder) Once you totally remove JS from a web page, and learn the shortcuts and efficiencies provided by a library like jQuery, one realizes that one can build generalized builders of JavaScript applications. One example is: Universal Automatic Drag-and-Drop Activity Builder (builds the code
5
2069
by: =?Utf-8?B?UGFycm90?= | last post by:
Is there a way to perform a drag drop from a list box to a Gridview control on a web page? I can do it in a Windows form but I can't figure out how to do it on a web page. Dave
0
8470
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8142
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8329
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6813
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6010
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
3959
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4022
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1580
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1327
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.