SQL

java.lang.Object
- org.pentaho.di.core.sql.SQL

```
public class SQL
extends Object
```

Constructor Summary

Constructors
Constructor and Description

SQL(String sqlString)
Create a new SQL object by parsing the supplied SQL string.

Constructors
Constructor and Description
`SQL(String sqlString)` Create a new SQL object by parsing the supplied SQL string.

Method Summary

Methods
Modifier and Type	Method and Description
`String`	`getGroupClause()`
`SQLFields`	`getGroupFields()`
`String`	`getHavingClause()`
`SQLCondition`	`getHavingCondition()`
`String`	`getLimitClause()`
`SQLLimit`	`getLimitValues()`
`String`	`getNamespace()`
`String`	`getOrderClause()`
`SQLFields`	`getOrderFields()`
`RowMetaInterface`	`getRowMeta()`
`String`	`getSelectClause()`
`SQLFields`	`getSelectFields()`
`String`	`getServiceName()`
`String`	`getSqlString()`
`String`	`getWhereClause()`
`SQLCondition`	`getWhereCondition()`
`void`	`parse(RowMetaInterface rowMeta)`
`void`	`setGroupClause(String groupClause)`
`void`	`setGroupFields(SQLFields groupFields)`
`void`	`setHavingClause(String havingClause)`
`void`	`setHavingCondition(SQLCondition havingCondition)`
`void`	`setLimitClause(String limitClause)`
`void`	`setLimitValues(SQLLimit limitValues)`
`void`	`setOrderClause(String orderClause)`
`void`	`setOrderFields(SQLFields orderFields)`
`void`	`setRowMeta(RowMetaInterface rowMeta)`
`void`	`setSelectClause(String selectClause)`
`void`	`setSelectFields(SQLFields selectFields)`
`void`	`setServiceName(String serviceName)`
`void`	`setSqlString(String sqlString)`
`void`	`setWhereClause(String whereClause)`
`void`	`setWhereCondition(SQLCondition whereCondition)`

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - SQL
```
public SQL(String sqlString)
    throws KettleSQLException
```
    Create a new SQL object by parsing the supplied SQL string. This is a simple implementation with only one table allows
    
    Parameters:
    sqlString - the SQL string to parse
    serviceName - the name of the service this SQL references
    rowMeta - the row layout of the service
    
    Throws:
    
    KettleSQLException - in case there is a SQL parsing error
- Method Detail
  - parse
```
public void parse(RowMetaInterface rowMeta)
           throws KettleSQLException
```
    Throws:
    
    KettleSQLException
  - getSqlString
```
public String getSqlString()
```
  - getRowMeta
```
public RowMetaInterface getRowMeta()
```
  - getServiceName
```
public String getServiceName()
```
  - getSelectClause
```
public String getSelectClause()
```
    Returns:
    the selectClause
  - setSelectClause
```
public void setSelectClause(String selectClause)
```
    Parameters:
    selectClause - the selectClause to set
  - getWhereClause
```
public String getWhereClause()
```
    Returns:
    the whereClause
  - setWhereClause
```
public void setWhereClause(String whereClause)
```
    Parameters:
    whereClause - the whereClause to set
  - getGroupClause
```
public String getGroupClause()
```
    Returns:
    the groupClause
  - setGroupClause
```
public void setGroupClause(String groupClause)
```
    Parameters:
    groupClause - the groupClause to set
  - getHavingClause
```
public String getHavingClause()
```
    Returns:
    the havingClause
  - setHavingClause
```
public void setHavingClause(String havingClause)
```
    Parameters:
    havingClause - the havingClause to set
  - getOrderClause
```
public String getOrderClause()
```
    Returns:
    the orderClause
  - setOrderClause
```
public void setOrderClause(String orderClause)
```
    Parameters:
    orderClause - the orderClause to set
  - getLimitClause
```
public String getLimitClause()
```
    Returns:
    the limitClause
  - setLimitClause
```
public void setLimitClause(String limitClause)
```
    Parameters:
    limitClause - the orderClause to set
  - getLimitValues
```
public SQLLimit getLimitValues()
```
    Returns:
    the limitValues
  - setLimitValues
```
public void setLimitValues(SQLLimit limitValues)
```
    Parameters:
    limitValues - the limitValues to set
  - setSqlString
```
public void setSqlString(String sqlString)
```
    Parameters:
    sqlString - the sql string to set
  - getSelectFields
```
public SQLFields getSelectFields()
```
    Returns:
    the selectFields
  - setSelectFields
```
public void setSelectFields(SQLFields selectFields)
```
    Parameters:
    selectFields - the selectFields to set
  - getGroupFields
```
public SQLFields getGroupFields()
```
    Returns:
    the groupFields
  - setGroupFields
```
public void setGroupFields(SQLFields groupFields)
```
    Parameters:
    groupFields - the groupFields to set
  - getOrderFields
```
public SQLFields getOrderFields()
```
    Returns:
    the orderFields
  - setOrderFields
```
public void setOrderFields(SQLFields orderFields)
```
    Parameters:
    orderFields - the orderFields to set
  - getWhereCondition
```
public SQLCondition getWhereCondition()
```
    Returns:
    the whereCondition
  - setWhereCondition
```
public void setWhereCondition(SQLCondition whereCondition)
```
    Parameters:
    whereCondition - the whereCondition to set
  - setRowMeta
```
public void setRowMeta(RowMetaInterface rowMeta)
```
    Parameters:
    rowMeta - the rowMeta to set
  - setServiceName
```
public void setServiceName(String serviceName)
```
    Parameters:
    serviceName - the serviceName to set
  - getHavingCondition
```
public SQLCondition getHavingCondition()
```
    Returns:
    the havingCondition
  - setHavingCondition
```
public void setHavingCondition(SQLCondition havingCondition)
```
    Parameters:
    havingCondition - the havingCondition to set
  - getNamespace
```
public String getNamespace()
```
    Returns:
    the namespace

Class SQL

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

SQL

Method Detail

parse

getSqlString

getRowMeta

getServiceName

getSelectClause

setSelectClause

getWhereClause

setWhereClause

getGroupClause

setGroupClause

getHavingClause

setHavingClause

getOrderClause

setOrderClause

getLimitClause

setLimitClause

getLimitValues

setLimitValues

setSqlString

getSelectFields

setSelectFields

getGroupFields

setGroupFields

getOrderFields

setOrderFields

getWhereCondition

setWhereCondition

setRowMeta

setServiceName

getHavingCondition

setHavingCondition

getNamespace