# Package groovy.sql

## Package groovy.sql Description

Groovy helper classes for working with SQL data as Groovy objects

- Interface Summary
  Interface | Description
  --- | ---
  ExpandedVariable | Identifies a variable to be expanded into the sql string rather than representing a placeholder.
  GroovyResultSet | Represents an extent of objects
  InListParameter | Marker that expands a collection into a comma-separated list of positional placeholders when bound to a SQL `IN` clause.
  InOutParameter | A typed parameter passed to, and returned from a CallableStatement.
  InParameter | A typed parameter to pass to a query
  OutParameter | A parameter to be returned from a CallableStatement.
  ResultSetOutParameter | A ResultSet out parameter.

- Class Summary
  Class | Description
  --- | ---
  BatchingPreparedStatementWrapper | Class which delegates to a PreparedStatement but keeps track of a batch count size.
  BatchingStatementWrapper | Class which delegates to a Statement but keeps track of a batch count size.
  DataSet | An enhancement of Groovy's Sql class providing support for accessing and querying databases using POGO fields and operators rather than JDBC-level API calls and RDBMS column names.
  GroovyResultSetExtension | GroovyResultSetExtension implements additional logic for ResultSet.
  GroovyResultSetProxy | GroovyResultSetProxy is used to create a proxy for GroovyResultSet.
  GroovyRowResult | Represents an extent of objects.
  ResultSetMetaDataWrapper | This class defines a wrapper for accessing a specific column in `ResultSetMetaData`.
  Sql | A facade over Java's normal JDBC APIs providing greatly simplified resource management and result set handling.
  Sql.AbstractQueryCommand | Base command object for query operations that manage statement and connection lifecycle.
  SqlOrderByVisitor | Derives an SQL `ORDER BY` fragment from a simple sort closure, used by DataSet.
  SqlWhereVisitor | AST visitor used by DataSet to derive an SQL `WHERE` clause and positional parameter list from a supported filter closure.
  SqlWithParams | Holds an SQL string together with the positional parameters that should be bound to it.