Does a jQuery or JavaScript module exist that creates a SQL query builder interface?

Question

We are currently using something called QueryBuilderWidget that is based on script.aculo.us. This was implemented a while back, and I can't find the project's site anymore. But, it looks very similar to YUI's Query Builder.

The functionality is fine, but we don't use scriptaculous for anything else. The rest of the site uses jQuery or straight JavaScript. I'm looking for a module with similar features that is either straight JavaScript or jQuery. I have seen this plugin, and I could use that as a starting point, if there isn't anything else.

hiddentao · Accepted Answer · 2012-01-28 12:13:06Z

3

I recently released a JavaScript SQL query builder which works in the browser and with node.js - http://squeljs.org

answered Jan 28, 2012 at 12:13

hiddentao

3912 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Barbara Laird Over a year ago

That's interesting, but I'm more interested in the UI portion. I'm looking for something that makes it easy for an end user to filter data.

hiddentao Over a year ago

@Raynos only the source is in CoffeeScript. The main library is actually pre-compiled and minified Javascript.

salk31 · Accepted Answer · 2012-03-01 08:12:27Z

3

Possibly too late but I'm working on a JavaScript SQL Builder UI that will do joins etc http://redquerybuilder.appspot.com/ that might be of interest. At an early stage but I'm very interested in what features people think are missing/broken.

answered Mar 1, 2012 at 8:12

salk31

1,0152 gold badges10 silver badges13 bronze badges

3 Comments

Barbara Laird Over a year ago

I'll give it a try. Any thoughts on allowing ORs instead of just ANDs?

salk31 Over a year ago

Definitely. It is going to be part of the next milestone. I've got to have a proper think about how to make it clear to the user in what order the expression is going to be evaluated. My current preference is for "pretty printing" but I'm worried that is just clear to geeks so I need to test it out on non-technical users.

salk31 Over a year ago

I've put a first stab at and/or up. My email address is on there now if you want more detailed help.

patricksurry · Accepted Answer · 2015-08-10 17:45:13Z

1

I've been looking for a web-based ad-hoc 'pivot table' style UI, and stumbled on http://mistic100.github.io/jQuery-QueryBuilder/index.html which seems to do a nice job with the filter/where clause piece.

answered Aug 10, 2015 at 17:45

patricksurry

5,9782 gold badges31 silver badges39 bronze badges

Comments

Bhavik Chauhan · Accepted Answer · 2014-04-08 09:35:27Z

0

From here you could find your answer

https://github.com/gantir/jsexpbuilder

You can also customize it as per your requirement

answered Apr 8, 2014 at 9:35

Bhavik Chauhan

1262 silver badges7 bronze badges

Collectives™ on Stack Overflow

Does a jQuery or JavaScript module exist that creates a SQL query builder interface?

4 Answers 4

2 Comments

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related