| @NotNull Optional<Record> | DSLContext. fetchOptional(ResultSet rs) |  | 
| @NotNull Record | DSLContext. fetchSingle(String sql) | Execute a new query holding plain SQL. | 
| @NotNull Record | DSLContext. fetchSingle(String sql,
           Object... bindings) | Execute a new query holding plain SQL. | 
| @NotNull Record | DSLContext. fetchSingle(String sql,
           QueryPart... parts) | Execute a new query holding plain SQL. | 
| @NotNull Record | DSLContext. fetchSingle(ResultSet rs,
           Class<?>... types) |  | 
| @NotNull Record | DSLContext. fetchSingle(ResultSet rs,
           DataType<?>... types) |  | 
| @NotNull Record | DSLContext. fetchSingle(ResultSet rs,
           Field<?>... fields) |  | 
| <R extends Record>R
 | DSLContext. fetchSingle(ResultQuery<R> query) | Execute a  ResultQuery in the context of this  DSLContext and return
 a record. | 
| @NotNull Record | DSLContext. fetchSingle(SQL sql) | Execute a new query holding plain SQL. | 
| <R extends Record>R
 | DSLContext. fetchSingle(Table<R> table) | Execute and return exactly one record for
  | 
| <R extends Record>R
 | DSLContext. fetchSingle(Table<R> table,
           Collection<? extends Condition> conditions) | Execute and return exactly one record for
  | 
| <R extends Record>R
 | DSLContext. fetchSingle(Table<R> table,
           Condition condition) | Execute and return exactly one record for
  | 
| <R extends Record>R
 | DSLContext. fetchSingle(Table<R> table,
           Condition... conditions) | Execute and return exactly one record for
  | 
| R | ResultQuery. fetchSingle() | Execute the query and return exactly one resulting record. | 
| @Nullable Object | ResultQuery. fetchSingle(int fieldIndex) | Execute the query and return exactly one resulting value for a field
 index from the generated result. | 
| <U> U | ResultQuery. fetchSingle(int fieldIndex,
           Class<? extends U> type) | Execute the query and return exactly one resulting value for a field
 index from the generated result. | 
| <U> U | ResultQuery. fetchSingle(int fieldIndex,
           Converter<?,? extends U> converter) | Execute the query and return exactly one resulting value for a field
 index from the generated result. | 
| @Nullable Object | ResultQuery. fetchSingle(String fieldName) | Execute the query and return exactly one resulting value for a field name
 from the generated result. | 
| <U> U | ResultQuery. fetchSingle(String fieldName,
           Class<? extends U> type) | Execute the query and return exactly one resulting value for a field name
 from the generated result. | 
| <U> U | ResultQuery. fetchSingle(String fieldName,
           Converter<?,? extends U> converter) | Execute the query and return exactly one resulting value for a field name
 from the generated result. | 
| <U> U | ResultQuery. fetchSingle(Field<?> field,
           Class<? extends U> type) | Execute the query and return exactly one resulting value for a field from
 the generated result. | 
| <T> T | ResultQuery. fetchSingle(Field<T> field) | Execute the query and return exactly one resulting value for a field from
 the generated result. | 
| <T,U>U
 | ResultQuery. fetchSingle(Field<T> field,
           Converter<? super T,? extends U> converter) | Execute the query and return exactly one resulting value for a field from
 the generated result. | 
| @Nullable Object | ResultQuery. fetchSingle(Name fieldName) | Execute the query and return exactly one resulting value for a field name
 from the generated result. | 
| <U> U | ResultQuery. fetchSingle(Name fieldName,
           Class<? extends U> type) | Execute the query and return exactly one resulting value for a field name
 from the generated result. | 
| <U> U | ResultQuery. fetchSingle(Name fieldName,
           Converter<?,? extends U> converter) | Execute the query and return exactly one resulting value for a field name
 from the generated result. | 
| <E> E | ResultQuery. fetchSingle(RecordMapper<? super R,E> mapper) | Execute the query and return exactly one resulting value into a custom
 mapper callback. | 
| @NotNull Object[] | ResultQuery. fetchSingleArray() | Execute the query and return exactly one resulting record as an array | 
| <E> E | ResultQuery. fetchSingleInto(Class<? extends E> type) | Map resulting records onto a custom type. | 
| <Z extends Record>Z
 | ResultQuery. fetchSingleInto(Table<Z> table) | Map resulting records onto a custom record. | 
| @NotNull Map<String,Object> | ResultQuery. fetchSingleMap() | Execute the query and return exactly one resulting record as a name/value
 map. | 
| void | UpdatableRecord. refresh(Collection<? extends Field<?>> fields) | Refresh parts of this record from the database. | 
| void | UpdatableRecord. refresh(Field<?>... fields) | Refresh parts of this record from the database. |