General Notes

Almost every method has a "custom" variation which supports inserting more complicated objects in place of the more common ones. The custom variation will often handle a range of Object types automatically.

Example Common Method	Equivalent Custom Method
SelectQuery.addColumns(Column...)	SelectQuery.addCustomColumns(Object...)

Most constructors which take an enum value have a named static method for constructing the object with each enum value.

Example Constructor With Enum	Equivalent Static Method
new ComboCondition(Op.AND)	ComboCondition.and()

DDL Queries

  CREATE TABLE <tableName> (<column> [ <columnConstraint> ], ...)
  [ TABLESPACE <tableSpace> ]

  CREATE INDEX <indexName> ON <table> (<column>, ...)
  [ TABLESPACE <tableSpace> ]

  CREATE VIEW [ <viewName> (<column>, ...) ]
  AS <selectQuery>
  [ WITH CHECK OPTION ]

  ALTER TABLE <table> <action>

  DROP <objType> <objName> [ <behavior> ]

  GRANT <privilege>, ... ON <target> TO <grantee>, ... [ WITH GRANT OPTION ]

  REVOKE <privilege>, ... ON <target> FROM <grantee>, ... [ <behavior> ]

DML Queries

  SELECT [ DISTINCT ] <column>, ...
  FROM [ <join>, ... ] | [ <table>, ... ]
  [ WHERE <condition> ]
  [ GROUP BY <group>, ...
    [ HAVING <havingCondition> ] ]
  [ ORDER BY <ordering> [ <orderingDir> ], ... ]
  [ FOR UPDATE ]

  INSERT INTO <table> ( <column>, ... ) VALUES ( <value>, ... )

  INSERT INTO <table> ( <column>, ... ) <selectQuery>

  DELETE FROM <table>
  [ WHERE <condition> ]

  <selectQuery> UNION [ ALL ] <selectQuery> ...
  [ ORDER BY <ordering> [ <orderingDir> ], ... ]

  UPDATE <table> SET <column> = <value>, ...
  [ WHERE <condition> ]

  ( <subQuery> )

Conditions

Condition objects represent boolean clauses. All conditions have logic for determining whether or not they actually contain any content and will not write anything to the generated query if they consider themselves empty.

  ( <subCondition> [ <comboOp> <subCondition> ... ] )

  ( <unaryOp> <value> )

  ( <value1> <binaryOp> <value2>)

  ( <column> [ NOT ] IN ( <value> , ... ) )

  ( NOT <subCondition> )

  ( <customCondition> )

Expressions

Expression objects represent value clauses. All expressions have similar logic to Conditions for handling empty content.

  ( <subExpression> [ <comboOp> <subExpression> ... ] )

  ( - <subExpression> )

  ( <customExpression> )

Simple Values

  '<value>'

  <number>

Complex Values

  ( CASE <column>
    WHEN <value> THEN <result>
    [ WHEN <value> THEN <result> ... ]
    [ ELSE <elseResult> ]
    END )

  ( CASE
    WHEN <condition> THEN <result>
    [ WHEN <condition> THEN <result> ... ]
    [ ELSE <elseResult> ]
    END )

  <functionName>( [ DISTINCT ] [ <parameter>, ... ] )

  -- <myCommentHere>\n

  <obj> AS <alias>

  <customSql>

JDBC Support

  { <escapeType> <sql> }

  { fn <funcCall> }