Catalysoft   Turtle
home products articles about us contact us

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

A9AlgernonantAOPArtificial Intelligence
awkBeanShellCCamel CaseCastor
Cladonia Exchanger XML EditorCLISPcollabetitioncygwinDAO
DOMEclipseEditiXErlangExpert System
Extreme ProgrammingFirefoxfirst class objectFortranFreeMind
GroovyHaskellHIBERNATEHSQLIDE
JathaJavaJAXBjBPMJDBC
JENAJESSJRulesJUnitJython
KerberosLISPMalwareOMGProlog
ProtegePythonRDFSESAMESUMO
SwoogleTrojan HorseXML-Java BindingXMLSpy