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.

Squiggle Features

• Concise and intuitive API.
• Simple code, so easy to customize.
• No dependencies on classes outside of JDK1.2.
• Small, lightweight, fast.
• Generates clean SQL designed that is very human readable.
• Supports joins and sub-selects.

Example

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

Other Terms