What is 'Squiggle'?
Squiggle is a small Java library for dynamically building complicated SQL SELECT statements.
Squiggle is open source code with the single focussed purpose of generating SQL SELECT statements based on criteria you give it. It is most useful when used in applications that need to build up complicated queries with criteria that change at runtime.
Table people = new Table("people"); SelectQuery select = new SelectQuery(people); select.addColumn(people, "firstname"); select.addColumn(people, "lastname"); select.addOrder(people, "age", Order.DESCENDING); System.out.println(select);
This generates the following output:
SELECT people.firstname , people.lastname FROM people ORDER BY people.age DESC
For more information, go to the Squiggle Home Page