How to use

getSQL

method

in

org.h2.expression.Expression

@Override
public String getSQL() {
  String sql = NAME + "(" + min.getSQL() + ", " + max.getSQL();
  if (step != null) {
    sql += ", " + step.getSQL();
  }
  return sql + ")";
}

/**
 * Convert this expression to a String.
 *
 * @return the string representation
 */
@Override
public String toString() {
  return getSQL();
}

@Override
public String getSQL() {
  String sql;
  if (regexp) {
    sql = left.getSQL() + " REGEXP " + right.getSQL();
  } else {
    sql = left.getSQL() + " LIKE " + right.getSQL();
    if (escape != null) {
      sql += " ESCAPE " + escape.getSQL();
    }
  }
  return "(" + sql + ")";
}

String getDefaultSQL() {
  return defaultExpression == null ? null : defaultExpression.getSQL();
}

@Override
public String getSQL() {
  return "(NOT " + condition.getSQL() + ")";
}

String getOnUpdateSQL() {
  return onUpdateExpression == null ? null : onUpdateExpression.getSQL();
}

@Override
public String getSQL() {
  String sql;
  switch (andOrType) {
  case AND:
    sql = left.getSQL() + "\n    AND " + right.getSQL();
    break;
  case OR:
    sql = left.getSQL() + "\n    OR " + right.getSQL();
    break;
  default:
    throw DbException.throwInternalError("andOrType=" + andOrType);
  }
  return "(" + sql + ")";
}

@Override
public String getSQL() {
  String sql;
  if (opType == OpType.NEGATE) {
    // don't remove the space, otherwise it might end up some thing like
    // --1 which is a line remark
    sql = "- " + left.getSQL();
  } else {
    // don't remove the space, otherwise it might end up some thing like
    // --1 which is a line remark
    sql = left.getSQL() + " " + getOperationToken() + " " + right.getSQL();
  }
  return "(" + sql + ")";
}

/**
 * Get the alias name of a column or SQL expression
 * if it is not an aliased expression.
 *
 * @return the alias name
 */
public String getAlias() {
  return StringUtils.unEnclose(getSQL());
}

/**
 * Get the check constraint SQL snippet.
 *
 * @param session the session
 * @param asColumnName the column name to use
 * @return the SQL snippet
 */
String getCheckConstraintSQL(Session session, String asColumnName) {
  Expression constraint = getCheckConstraint(session, asColumnName);
  return constraint == null ? "" : constraint.getSQL();
}

@Override
public String getSQL() {
  return expr.getSQL() + " AS " + Parser.quoteIdentifier(alias);
}

@Override
public String getSQL() {
  return '(' + left.getSQL() + " = ANY(" + parameter.getSQL() + "))";
}

private String getShortDescription() {
  return getName() + ": " + expr.getSQL();
}

private static void checkDefaultReferencesTable(Table table, Expression defaultExpression) {
  if (defaultExpression == null) {
    return;
  }
  HashSet<DbObject> dependencies = new HashSet<>();
  ExpressionVisitor visitor = ExpressionVisitor
      .getDependenciesVisitor(dependencies);
  defaultExpression.isEverything(visitor);
  if (dependencies.contains(table)) {
    throw DbException.get(ErrorCode.COLUMN_IS_REFERENCED_1,
        defaultExpression.getSQL());
  }
}

@Override
public String getSQL() {
  StatementBuilder buff = new StatementBuilder("(");
  buff.append(left.getSQL()).append(" IN(");
  for (Expression e : valueList) {
    buff.appendExceptFirst(", ");
    buff.append(e.getSQL());
  }
  return buff.append("))").toString();
}

@Override
public String getSQL() {
  StatementBuilder buff = new StatementBuilder("(");
  buff.append(left.getSQL()).append(" IN(");
  for (Expression e : valueList) {
    buff.appendExceptFirst(", ");
    buff.append(e.getSQL());
  }
  return buff.append("))").toString();
}

@Override
public String getSQL() {
  StatementBuilder buff = new StatementBuilder("(");
  for (Expression e: list) {
    buff.appendExceptFirst(", ");
    buff.append(e.getSQL());
  }
  if (list.length == 1) {
    buff.append(',');
  }
  return buff.append(')').toString();
}

@Override
public String getSQL() {
  StatementBuilder buff = new StatementBuilder();
  buff.append(Parser.quoteIdentifier(userAggregate.getName())).append('(');
  for (Expression e : args) {
    buff.appendExceptFirst(", ");
    buff.append(e.getSQL());
  }
  buff.append(')');
  if (filterCondition != null) {
    buff.append(" FILTER (WHERE ").append(filterCondition.getSQL()).append(')');
  }
  return buff.toString();
}

@Override
public void checkExistingData(Session session) {
  if (session.getDatabase().isStarting()) {
    // don't check at startup
    return;
  }
  String sql = "SELECT 1 FROM " + filter.getTable().getSQL() +
      " WHERE NOT(" + expr.getSQL() + ")";
  ResultInterface r = session.prepare(sql).query(1);
  if (r.next()) {
    throw DbException.get(ErrorCode.CHECK_CONSTRAINT_VIOLATED_1, getName());
  }
}

@Override
public String getSQL() {
  StatementBuilder buff = new StatementBuilder(getName());
  buff.append('(');
  int i = 0;
  for (Expression e : args) {
    buff.appendExceptFirst(", ");
    buff.append(columnList[i++].getCreateSQL()).append('=').append(e.getSQL());
  }
  return buff.append(')').toString();
}