# Class SQLBuilder

java.lang.Object
org.apache.cayenne.access.sqlbuilder.SQLBuilder

public final class SQLBuilder extends Object

Since:
  4.2

- ## Method Summary

  Modifier and Type
  Method
  Description
  `static NodeBuilder`
  `aliased(NodeBuilder nodeBuilder, String alias)`
  `static NodeBuilder`
  `aliased(Node node, String alias)`
  `static NodeBuilder`
  `all()`
  `static FunctionNodeBuilder`
  `avg(NodeBuilder value)`
  `static org.apache.cayenne.access.sqlbuilder.WhenBuilder`
  `caseWhen(NodeBuilder param)`
  `static ColumnNodeBuilder`
  `column(String column)`
  `static FunctionNodeBuilder`
  `count()`
  `static FunctionNodeBuilder`
  `count(NodeBuilder value)`
  `static DeleteBuilder`
  `delete(String table)`
  `static DeleteBuilder`
  `delete(DbEntity table)`
  `static ExpressionNodeBuilder`
  `exists(NodeBuilder builder)`
  `static ExpressionNodeBuilder`
  `exp(NodeBuilder builder)`
  `static FunctionNodeBuilder`
  `function(String function, NodeBuilder... values)`
  `static JoinNodeBuilder`
  `innerJoin(NodeBuilder table)`
  `static InsertBuilder`
  `insert(String table)`
  `static InsertBuilder`
  `insert(DbEntity table)`
  `static JoinNodeBuilder`
  `join(NodeBuilder table)`
  `static JoinNodeBuilder`
  `leftJoin(NodeBuilder table)`
  `static FunctionNodeBuilder`
  `max(NodeBuilder value)`
  `static FunctionNodeBuilder`
  `min(NodeBuilder value)`
  `static NodeBuilder`
  `node(Node node)`
  `static ExpressionNodeBuilder`
  `not(NodeBuilder value)`
  `static OrderingNodeBuilder`
  `order(NodeBuilder expression)`
  `static JoinNodeBuilder`
  `outerJoin(NodeBuilder table)`
  `static JoinNodeBuilder`
  `rightJoin(NodeBuilder table)`
  `static SelectBuilder`
  `select(NodeBuilder... params)`
  `static TableNodeBuilder`
  `table(String table)`
  `static TableNodeBuilder`
  `table(DbEntity table)`
  `static NodeBuilder`
  `text(String text)`
  `static UpdateBuilder`
  `update(String table)`
  `static UpdateBuilder`
  `update(DbEntity table)`
  `static ValueNodeBuilder`
  `value(Object value)`

  ### Methods inherited from class Object

  `clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

- ## Method Details

  - ### select

    public static SelectBuilder select(NodeBuilder... params)

  - ### insert

    public static InsertBuilder insert(String table)

  - ### insert

    public static InsertBuilder insert(DbEntity table)

  - ### update

    public static UpdateBuilder update(String table)

  - ### update

    public static UpdateBuilder update(DbEntity table)

  - ### delete

    public static DeleteBuilder delete(String table)

  - ### delete

    public static DeleteBuilder delete(DbEntity table)

  - ### table

    public static TableNodeBuilder table(String table)

  - ### table

    public static TableNodeBuilder table(DbEntity table)

  - ### column

    public static ColumnNodeBuilder column(String column)

  - ### caseWhen

    public static org.apache.cayenne.access.sqlbuilder.WhenBuilder caseWhen(NodeBuilder param)

  - ### join

    public static JoinNodeBuilder join(NodeBuilder table)

  - ### leftJoin

    public static JoinNodeBuilder leftJoin(NodeBuilder table)

  - ### rightJoin

    public static JoinNodeBuilder rightJoin(NodeBuilder table)

  - ### innerJoin

    public static JoinNodeBuilder innerJoin(NodeBuilder table)

  - ### outerJoin

    public static JoinNodeBuilder outerJoin(NodeBuilder table)

  - ### exists

    public static ExpressionNodeBuilder exists(NodeBuilder builder)

  - ### value

    public static ValueNodeBuilder value(Object value)

  - ### exp

    public static ExpressionNodeBuilder exp(NodeBuilder builder)

  - ### node

    public static NodeBuilder node(Node node)

  - ### aliased

    public static NodeBuilder aliased(NodeBuilder nodeBuilder, String alias)

  - ### aliased

    public static NodeBuilder aliased(Node node, String alias)

  - ### text

    public static NodeBuilder text(String text)

  - ### all

    public static NodeBuilder all()

  - ### not

    public static ExpressionNodeBuilder not(NodeBuilder value)

  - ### count

    public static FunctionNodeBuilder count(NodeBuilder value)

  - ### count

    public static FunctionNodeBuilder count()

  - ### avg

    public static FunctionNodeBuilder avg(NodeBuilder value)

  - ### min

    public static FunctionNodeBuilder min(NodeBuilder value)

  - ### max

    public static FunctionNodeBuilder max(NodeBuilder value)

  - ### function

    public static FunctionNodeBuilder function(String function, NodeBuilder... values)

  - ### order

    public static OrderingNodeBuilder order(NodeBuilder expression)