Module org.jooq
Package org.jooq

Interface Fetchable<R extends Record>

    • Method Summary

      All Methods Instance Methods Abstract Methods Default Methods 
      Modifier and Type Method Description
      <X,​A>
      X
      collect​(Collector<? super R,​A,​X> collector)
      Reduce the execution results of this query using a Collector.
      @NotNull Result<R> fetch()
      Execute the query and return the generated result.
      @NotNull List<?> fetch​(int fieldIndex)
      Execute the query and return all values for a field index from the generated result.
      <U> @NotNull List<U> fetch​(int fieldIndex, Class<? extends U> type)
      Execute the query and return all values for a field index from the generated result.
      <U> @NotNull List<U> fetch​(int fieldIndex, Converter<?,​? extends U> converter)
      Execute the query and return all values for a field index from the generated result.
      @NotNull List<?> fetch​(String fieldName)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull List<U> fetch​(String fieldName, Class<? extends U> type)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull List<U> fetch​(String fieldName, Converter<?,​? extends U> converter)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull List<U> fetch​(Field<?> field, Class<? extends U> type)
      Execute the query and return all values for a field from the generated result.
      <T> @NotNull List<T> fetch​(Field<T> field)
      Execute the query and return all values for a field from the generated result.
      <T,​U>
      @NotNull List<U>
      fetch​(Field<T> field, Converter<? super T,​? extends U> converter)
      Execute the query and return all values for a field from the generated result.
      @NotNull List<?> fetch​(Name fieldName)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull List<U> fetch​(Name fieldName, Class<? extends U> type)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull List<U> fetch​(Name fieldName, Converter<?,​? extends U> converter)
      Execute the query and return all values for a field name from the generated result.
      <E> @NotNull List<E> fetch​(RecordMapper<? super R,​E> mapper)
      Fetch results into a custom mapper callback.
      R fetchAny()
      Execute the query and return at most one resulting record.
      @Nullable Object fetchAny​(int fieldIndex)
      Execute the query and return at most one resulting value for a field index from the generated result.
      <U> U fetchAny​(int fieldIndex, Class<? extends U> type)
      Execute the query and return at most one resulting value for a field index from the generated result.
      <U> U fetchAny​(int fieldIndex, Converter<?,​? extends U> converter)
      Execute the query and return at most one resulting value for a field index from the generated result.
      @Nullable Object fetchAny​(String fieldName)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> U fetchAny​(String fieldName, Class<? extends U> type)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> U fetchAny​(String fieldName, Converter<?,​? extends U> converter)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> U fetchAny​(Field<?> field, Class<? extends U> type)
      Execute the query and return at most one resulting value for a field from the generated result.
      <T> T fetchAny​(Field<T> field)
      Execute the query and return at most one resulting value for a field from the generated result.
      <T,​U>
      U
      fetchAny​(Field<T> field, Converter<? super T,​? extends U> converter)
      Execute the query and return at most one resulting value for a field from the generated result.
      @Nullable Object fetchAny​(Name fieldName)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> U fetchAny​(Name fieldName, Class<? extends U> type)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> U fetchAny​(Name fieldName, Converter<?,​? extends U> converter)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <E> E fetchAny​(RecordMapper<? super R,​E> mapper)
      Execute the query and return at most one resulting record.
      @Nullable Object[] fetchAnyArray()
      Execute the query and return at most one resulting record as an array
      <E> E fetchAnyInto​(Class<? extends E> type)
      Map resulting records onto a custom type.
      <Z extends Record>
      Z
      fetchAnyInto​(Table<Z> table)
      Map resulting records onto a custom record.
      @Nullable Map<String,​Object> fetchAnyMap()
      Execute the query and return at most one resulting record as a name/value map.
      @NotNull R[] fetchArray()
      Execute the query and return the generated result as an array of records.
      @NotNull Object[] fetchArray​(int fieldIndex)
      Execute the query and return all values for a field index from the generated result.
      <U> @NotNull U[] fetchArray​(int fieldIndex, Class<? extends U> type)
      Execute the query and return all values for a field index from the generated result.
      <U> @NotNull U[] fetchArray​(int fieldIndex, Converter<?,​? extends U> converter)
      Execute the query and return all values for a field index from the generated result.
      @NotNull Object[] fetchArray​(String fieldName)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull U[] fetchArray​(String fieldName, Class<? extends U> type)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull U[] fetchArray​(String fieldName, Converter<?,​? extends U> converter)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull U[] fetchArray​(Field<?> field, Class<? extends U> type)
      Execute the query and return all values for a field from the generated result.
      <T> @NotNull T[] fetchArray​(Field<T> field)
      Execute the query and return all values for a field from the generated result.
      <T,​U>
      @NotNull U[]
      fetchArray​(Field<T> field, Converter<? super T,​? extends U> converter)
      Execute the query and return all values for a field from the generated result.
      @NotNull Object[] fetchArray​(Name fieldName)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull U[] fetchArray​(Name fieldName, Class<? extends U> type)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull U[] fetchArray​(Name fieldName, Converter<?,​? extends U> converter)
      Execute the query and return all values for a field name from the generated result.
      @NotNull Object[][] fetchArrays()
      Execute the query and return the generated result as an Object matrix.
      @NotNull CompletionStage<Result<R>> fetchAsync()
      Fetch results in a new CompletionStage.
      @NotNull CompletionStage<Result<R>> fetchAsync​(Executor executor)
      Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.
      @NotNull Map<?,​Result<R>> fetchGroups​(int keyFieldIndex)
      Execute the query and return a Map with one of the result's columns as key and a list of corresponding records as value.
      @NotNull Map<Record,​Result<R>> fetchGroups​(int[] keyFieldIndexes)
      Execute the query and return a Map with the result grouped by the given keys.
      @NotNull Map<Record,​Result<Record>> fetchGroups​(int[] keyFieldIndexes, int[] valueFieldIndexes)
      Execute the query and return a Map with the result grouped by the given keys.
      <E> @NotNull Map<Record,​List<E>> fetchGroups​(int[] keyFieldIndexes, Class<? extends E> type)
      Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type.
      <E> @NotNull Map<Record,​List<E>> fetchGroups​(int[] keyFieldIndexes, RecordMapper<? super R,​E> mapper)
      Execute the query and return a Map with results grouped by the given keys and mapped by the given mapper.
      @NotNull Map<?,​List<?>> fetchGroups​(int keyFieldIndex, int valueFieldIndex)
      Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value
      <E> @NotNull Map<?,​List<E>> fetchGroups​(int keyFieldIndex, Class<? extends E> type)
      Return a Map with results grouped by the given key and mapped into the given entity type.
      <E> @NotNull Map<?,​List<E>> fetchGroups​(int keyFieldIndex, RecordMapper<? super R,​E> mapper)
      Return a Map with results grouped by the given key and mapped by the given mapper.
      <K> @NotNull Map<K,​Result<R>> fetchGroups​(Class<? extends K> keyType)
      Execute the query and return a Map with results grouped by the given key entity.
      <K,​V>
      @NotNull Map<K,​List<V>>
      fetchGroups​(Class<? extends K> keyType, Class<? extends V> valueType)
      Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type.
      <K,​V>
      @NotNull Map<K,​List<V>>
      fetchGroups​(Class<? extends K> keyType, RecordMapper<? super R,​V> valueMapper)
      Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type.
      @NotNull Map<?,​Result<R>> fetchGroups​(String keyFieldName)
      Execute the query and return a Map with one of the result's columns as key and a list of corresponding records as value.
      @NotNull Map<Record,​Result<R>> fetchGroups​(String[] keyFieldNames)
      Execute the query and return a Map with the result grouped by the given keys.
      <E> @NotNull Map<Record,​List<E>> fetchGroups​(String[] keyFieldNames, Class<? extends E> type)
      Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type.
      @NotNull Map<Record,​Result<Record>> fetchGroups​(String[] keyFieldNames, String[] valueFieldNames)
      Execute the query and return a Map with the result grouped by the given keys.
      <E> @NotNull Map<Record,​List<E>> fetchGroups​(String[] keyFieldNames, RecordMapper<? super R,​E> mapper)
      Execute the query and return a Map with results grouped by the given keys and mapped by the given mapper.
      <E> @NotNull Map<?,​List<E>> fetchGroups​(String keyFieldName, Class<? extends E> type)
      Return a Map with results grouped by the given key and mapped into the given entity type.
      @NotNull Map<?,​List<?>> fetchGroups​(String keyFieldName, String valueFieldName)
      Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value
      <E> @NotNull Map<?,​List<E>> fetchGroups​(String keyFieldName, RecordMapper<? super R,​E> mapper)
      Return a Map with results grouped by the given key and mapped by the given mapper.
      @NotNull Map<Record,​Result<R>> fetchGroups​(Field<?>[] keys)
      Execute the query and return a Map with the result grouped by the given keys.
      <E> @NotNull Map<Record,​List<E>> fetchGroups​(Field<?>[] keys, Class<? extends E> type)
      Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type.
      @NotNull Map<Record,​Result<Record>> fetchGroups​(Field<?>[] keys, Field<?>[] values)
      Execute the query and return a Map with the result grouped by the given keys.
      <E> @NotNull Map<Record,​List<E>> fetchGroups​(Field<?>[] keys, RecordMapper<? super R,​E> mapper)
      Execute the query and return a Map with results grouped by the given keys and mapped by the given mapper.
      <K> @NotNull Map<K,​Result<R>> fetchGroups​(Field<K> key)
      Execute the query and return a Map with one of the result's columns as key and a list of corresponding records as value.
      <K,​E>
      @NotNull Map<K,​List<E>>
      fetchGroups​(Field<K> key, Class<? extends E> type)
      Return a Map with results grouped by the given key and mapped into the given entity type.
      <K,​V>
      @NotNull Map<K,​List<V>>
      fetchGroups​(Field<K> key, Field<V> value)
      Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value
      <K,​E>
      @NotNull Map<K,​List<E>>
      fetchGroups​(Field<K> key, RecordMapper<? super R,​E> mapper)
      Return a Map with results grouped by the given key and mapped by the given mapper.
      @NotNull Map<?,​Result<R>> fetchGroups​(Name keyFieldName)
      Execute the query and return a Map with one of the result's columns as key and a list of corresponding records as value.
      @NotNull Map<Record,​Result<R>> fetchGroups​(Name[] keyFieldNames)
      Execute the query and return a Map with the result grouped by the given keys.
      <E> @NotNull Map<Record,​List<E>> fetchGroups​(Name[] keyFieldNames, Class<? extends E> type)
      Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type.
      @NotNull Map<Record,​Result<Record>> fetchGroups​(Name[] keyFieldNames, Name[] valueFieldNames)
      Execute the query and return a Map with the result grouped by the given keys.
      <E> @NotNull Map<Record,​List<E>> fetchGroups​(Name[] keyFieldNames, RecordMapper<? super R,​E> mapper)
      Execute the query and return a Map with results grouped by the given keys and mapped by the given mapper.
      <E> @NotNull Map<?,​List<E>> fetchGroups​(Name keyFieldName, Class<? extends E> type)
      Return a Map with results grouped by the given key and mapped into the given entity type.
      @NotNull Map<?,​List<?>> fetchGroups​(Name keyFieldName, Name valueFieldName)
      Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value
      <E> @NotNull Map<?,​List<E>> fetchGroups​(Name keyFieldName, RecordMapper<? super R,​E> mapper)
      Return a Map with results grouped by the given key and mapped by the given mapper.
      <K> @NotNull Map<K,​Result<R>> fetchGroups​(RecordMapper<? super R,​K> keyMapper)
      Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type.
      <K,​V>
      @NotNull Map<K,​List<V>>
      fetchGroups​(RecordMapper<? super R,​K> keyMapper, Class<V> valueType)
      Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type.
      <K,​V>
      @NotNull Map<K,​List<V>>
      fetchGroups​(RecordMapper<? super R,​K> keyMapper, RecordMapper<? super R,​V> valueMapper)
      Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type.
      <S extends Record>
      @NotNull Map<S,​Result<R>>
      fetchGroups​(Table<S> table)
      Execute the query and return a Map with the result grouped by the given table.
      <E,​S extends Record>
      @NotNull Map<S,​List<E>>
      fetchGroups​(Table<S> table, Class<? extends E> type)
      Execute the query and return a Map with results grouped by the given table and mapped into the given entity type.
      <E,​S extends Record>
      @NotNull Map<S,​List<E>>
      fetchGroups​(Table<S> table, RecordMapper<? super R,​E> mapper)
      Execute the query and return a Map with results grouped by the given table and mapped by the given mapper.
      <S extends Record,​T extends Record>
      @NotNull Map<S,​Result<T>>
      fetchGroups​(Table<S> keyTable, Table<T> valueTable)
      Execute the query and return a Map with the result grouped by the given table.
      <H extends RecordHandler<? super R>>
      H
      fetchInto​(H handler)
      Fetch results into a custom handler callback.
      <E> @NotNull List<E> fetchInto​(Class<? extends E> type)
      Map resulting records onto a custom type.
      <Z extends Record>
      @NotNull Result<Z>
      fetchInto​(Table<Z> table)
      Map resulting records onto a custom record.
      @NotNull Cursor<R> fetchLazy()
      Execute the query and "lazily" return the generated result.
      @NotNull Results fetchMany()
      Execute a query, possibly returning several result sets.
      @NotNull Map<?,​R> fetchMap​(int keyFieldIndex)
      Execute the query and return a Map with one of the result's columns as key and the corresponding records as value.
      @NotNull Map<Record,​R> fetchMap​(int[] keyFieldIndexes)
      Execute the query and return a Map with keys as a map key and the corresponding record as value.
      @NotNull Map<Record,​Record> fetchMap​(int[] keyFieldIndexes, int[] valueFieldIndexes)
      Execute the query and return a Map with keys as a map key and the corresponding record as value.
      <E> @NotNull Map<List<?>,​E> fetchMap​(int[] keyFieldIndexes, Class<? extends E> type)
      Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type.
      <E> @NotNull Map<List<?>,​E> fetchMap​(int[] keyFieldIndexes, RecordMapper<? super R,​E> mapper)
      Execute the query and return a Map with results grouped by the given keys and mapped by the given mapper.
      @NotNull Map<?,​?> fetchMap​(int keyFieldIndex, int valueFieldIndex)
      Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value
      <E> @NotNull Map<?,​E> fetchMap​(int keyFieldIndex, Class<? extends E> type)
      Execute the query and return a Map with results grouped by the given key and mapped into the given entity type.
      <E> @NotNull Map<?,​E> fetchMap​(int keyFieldIndex, RecordMapper<? super R,​E> mapper)
      Execute the query and return a Map with results grouped by the given key and mapped by the given mapper.
      <K> @NotNull Map<K,​R> fetchMap​(Class<? extends K> keyType)
      Execute the query and return a Map with results grouped by the given key entity.
      <K,​V>
      @NotNull Map<K,​V>
      fetchMap​(Class<? extends K> keyType, Class<? extends V> valueType)
      Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type.
      <K,​V>
      @NotNull Map<K,​V>
      fetchMap​(Class<? extends K> keyType, RecordMapper<? super R,​V> valueMapper)
      Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type.
      @NotNull Map<?,​R> fetchMap​(String keyFieldName)
      Execute the query and return a Map with one of the result's columns as key and the corresponding records as value.
      @NotNull Map<Record,​R> fetchMap​(String[] keyFieldNames)
      Execute the query and return a Map with keys as a map key and the corresponding record as value.
      <E> @NotNull Map<List<?>,​E> fetchMap​(String[] keyFieldNames, Class<? extends E> type)
      Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type.
      @NotNull Map<Record,​Record> fetchMap​(String[] keyFieldNames, String[] valueFieldNames)
      Execute the query and return a Map with keys as a map key and the corresponding record as value.
      <E> @NotNull Map<List<?>,​E> fetchMap​(String[] keyFieldNames, RecordMapper<? super R,​E> mapper)
      Execute the query and return a Map with results grouped by the given keys and mapped by the given mapper.
      <E> @NotNull Map<?,​E> fetchMap​(String keyFieldName, Class<? extends E> type)
      Execute the query and return a Map with results grouped by the given key and mapped into the given entity type.
      @NotNull Map<?,​?> fetchMap​(String keyFieldName, String valueFieldName)
      Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value
      <E> @NotNull Map<?,​E> fetchMap​(String keyFieldName, RecordMapper<? super R,​E> mapper)
      Execute the query and return a Map with results grouped by the given key and mapped by the given mapper.
      @NotNull Map<Record,​R> fetchMap​(Field<?>[] keys)
      Execute the query and return a Map with keys as a map key and the corresponding record as value.
      <E> @NotNull Map<List<?>,​E> fetchMap​(Field<?>[] keys, Class<? extends E> type)
      Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type.
      @NotNull Map<Record,​Record> fetchMap​(Field<?>[] keys, Field<?>[] values)
      Execute the query and return a Map with keys as a map key and the corresponding record as value.
      <E> @NotNull Map<List<?>,​E> fetchMap​(Field<?>[] keys, RecordMapper<? super R,​E> mapper)
      Execute the query and return a Map with results grouped by the given keys and mapped by the given mapper.
      <K> @NotNull Map<K,​R> fetchMap​(Field<K> key)
      Execute the query and return a Map with one of the result's columns as key and the corresponding records as value.
      <K,​E>
      @NotNull Map<K,​E>
      fetchMap​(Field<K> key, Class<? extends E> type)
      Execute the query and return a Map with results grouped by the given key and mapped into the given entity type.
      <K,​V>
      @NotNull Map<K,​V>
      fetchMap​(Field<K> key, Field<V> value)
      Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value
      <K,​E>
      @NotNull Map<K,​E>
      fetchMap​(Field<K> key, RecordMapper<? super R,​E> mapper)
      Execute the query and return a Map with results grouped by the given key and mapped by the given mapper.
      @NotNull Map<?,​R> fetchMap​(Name keyFieldName)
      Execute the query and return a Map with one of the result's columns as key and the corresponding records as value.
      @NotNull Map<Record,​R> fetchMap​(Name[] keyFieldNames)
      Execute the query and return a Map with keys as a map key and the corresponding record as value.
      <E> @NotNull Map<List<?>,​E> fetchMap​(Name[] keyFieldNames, Class<? extends E> type)
      Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type.
      @NotNull Map<Record,​Record> fetchMap​(Name[] keyFieldNames, Name[] valueFieldNames)
      Execute the query and return a Map with keys as a map key and the corresponding record as value.
      <E> @NotNull Map<List<?>,​E> fetchMap​(Name[] keyFieldNames, RecordMapper<? super R,​E> mapper)
      Execute the query and return a Map with results grouped by the given keys and mapped by the given mapper.
      <E> @NotNull Map<?,​E> fetchMap​(Name keyFieldName, Class<? extends E> type)
      Execute the query and return a Map with results grouped by the given key and mapped into the given entity type.
      @NotNull Map<?,​?> fetchMap​(Name keyFieldName, Name valueFieldName)
      Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value
      <E> @NotNull Map<?,​E> fetchMap​(Name keyFieldName, RecordMapper<? super R,​E> mapper)
      Execute the query and return a Map with results grouped by the given key and mapped by the given mapper.
      <K> @NotNull Map<K,​R> fetchMap​(RecordMapper<? super R,​K> keyMapper)
      Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type.
      <K,​V>
      @NotNull Map<K,​V>
      fetchMap​(RecordMapper<? super R,​K> keyMapper, Class<V> valueType)
      Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type.
      <K,​V>
      @NotNull Map<K,​V>
      fetchMap​(RecordMapper<? super R,​K> keyMapper, RecordMapper<? super R,​V> valueMapper)
      Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type.
      <S extends Record>
      @NotNull Map<S,​R>
      fetchMap​(Table<S> table)
      Execute the query and return a Map with table as a map key and the corresponding record as value.
      <E,​S extends Record>
      @NotNull Map<S,​E>
      fetchMap​(Table<S> table, Class<? extends E> type)
      Execute the query and return a Map with results grouped by the given table and mapped into the given entity type.
      <E,​S extends Record>
      @NotNull Map<S,​E>
      fetchMap​(Table<S> table, RecordMapper<? super R,​E> mapper)
      Execute the query and return a Map with results grouped by the given table and mapped by the given mapper.
      <S extends Record,​T extends Record>
      @NotNull Map<S,​T>
      fetchMap​(Table<S> keyTable, Table<T> valueTable)
      Execute the query and return a Map with table as a map key and the corresponding record as value.
      @NotNull List<Map<String,​Object>> fetchMaps()
      Execute the query and return the generated result as a list of name/value maps.
      R fetchOne()
      Execute the query and return at most one resulting record.
      @Nullable Object fetchOne​(int fieldIndex)
      Execute the query and return at most one resulting value for a field index from the generated result.
      <U> U fetchOne​(int fieldIndex, Class<? extends U> type)
      Execute the query and return at most one resulting value for a field index from the generated result.
      <U> U fetchOne​(int fieldIndex, Converter<?,​? extends U> converter)
      Execute the query and return at most one resulting value for a field index from the generated result.
      @Nullable Object fetchOne​(String fieldName)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> U fetchOne​(String fieldName, Class<? extends U> type)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> U fetchOne​(String fieldName, Converter<?,​? extends U> converter)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> U fetchOne​(Field<?> field, Class<? extends U> type)
      Execute the query and return at most one resulting value for a field from the generated result.
      <T> T fetchOne​(Field<T> field)
      Execute the query and return at most one resulting value for a field from the generated result.
      <T,​U>
      U
      fetchOne​(Field<T> field, Converter<? super T,​? extends U> converter)
      Execute the query and return at most one resulting value for a field from the generated result.
      @Nullable Object fetchOne​(Name fieldName)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> U fetchOne​(Name fieldName, Class<? extends U> type)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> U fetchOne​(Name fieldName, Converter<?,​? extends U> converter)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <E> E fetchOne​(RecordMapper<? super R,​E> mapper)
      Execute the query and return at most one resulting value into a custom mapper callback.
      @Nullable Object[] fetchOneArray()
      Execute the query and return at most one resulting record as an array
      <E> E fetchOneInto​(Class<? extends E> type)
      Map resulting records onto a custom type.
      <Z extends Record>
      Z
      fetchOneInto​(Table<Z> table)
      Map resulting records onto a custom record.
      @Nullable Map<String,​Object> fetchOneMap()
      Execute the query and return at most one resulting record as a name/value map.
      @NotNull Optional<R> fetchOptional()
      Execute the query and return at most one resulting record.
      @NotNull Optional<?> fetchOptional​(int fieldIndex)
      Execute the query and return at most one resulting value for a field index from the generated result.
      <U> @NotNull Optional<U> fetchOptional​(int fieldIndex, Class<? extends U> type)
      Execute the query and return at most one resulting value for a field index from the generated result.
      <U> @NotNull Optional<U> fetchOptional​(int fieldIndex, Converter<?,​? extends U> converter)
      Execute the query and return at most one resulting value for a field index from the generated result.
      @NotNull Optional<?> fetchOptional​(String fieldName)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> @NotNull Optional<U> fetchOptional​(String fieldName, Class<? extends U> type)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> @NotNull Optional<U> fetchOptional​(String fieldName, Converter<?,​? extends U> converter)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> @NotNull Optional<U> fetchOptional​(Field<?> field, Class<? extends U> type)
      Execute the query and return at most one resulting value for a field from the generated result.
      <T> @NotNull Optional<T> fetchOptional​(Field<T> field)
      Execute the query and return at most one resulting value for a field from the generated result.
      <T,​U>
      @NotNull Optional<U>
      fetchOptional​(Field<T> field, Converter<? super T,​? extends U> converter)
      Execute the query and return at most one resulting value for a field from the generated result.
      @NotNull Optional<?> fetchOptional​(Name fieldName)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> @NotNull Optional<U> fetchOptional​(Name fieldName, Class<? extends U> type)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <U> @NotNull Optional<U> fetchOptional​(Name fieldName, Converter<?,​? extends U> converter)
      Execute the query and return at most one resulting value for a field name from the generated result.
      <E> @NotNull Optional<E> fetchOptional​(RecordMapper<? super R,​E> mapper)
      Execute the query and return at most one resulting value into a custom mapper callback.
      @NotNull Optional<Object[]> fetchOptionalArray()
      Execute the query and return at most one resulting record as an array.
      <E> @NotNull Optional<E> fetchOptionalInto​(Class<? extends E> type)
      Map resulting records onto a custom type.
      <Z extends Record>
      @NotNull Optional<Z>
      fetchOptionalInto​(Table<Z> table)
      Map resulting records onto a custom record.
      @NotNull Optional<Map<String,​Object>> fetchOptionalMap()
      Execute the query and return at most one resulting record as a name/value map.
      @NotNull ResultSet fetchResultSet()
      Execute the query and return the generated result as a JDBC ResultSet.
      @NotNull Set<?> fetchSet​(int fieldIndex)
      Execute the query and return all values for a field index from the generated result.
      <U> @NotNull Set<U> fetchSet​(int fieldIndex, Class<? extends U> type)
      Execute the query and return all values for a field index from the generated result.
      <U> @NotNull Set<U> fetchSet​(int fieldIndex, Converter<?,​? extends U> converter)
      Execute the query and return all values for a field index from the generated result.
      @NotNull Set<?> fetchSet​(String fieldName)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull Set<U> fetchSet​(String fieldName, Class<? extends U> type)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull Set<U> fetchSet​(String fieldName, Converter<?,​? extends U> converter)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull Set<U> fetchSet​(Field<?> field, Class<? extends U> type)
      Execute the query and return all values for a field from the generated result.
      <T> @NotNull Set<T> fetchSet​(Field<T> field)
      Execute the query and return all values for a field from the generated result.
      <T,​U>
      @NotNull Set<U>
      fetchSet​(Field<T> field, Converter<? super T,​? extends U> converter)
      Execute the query and return all values for a field from the generated result.
      @NotNull Set<?> fetchSet​(Name fieldName)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull Set<U> fetchSet​(Name fieldName, Class<? extends U> type)
      Execute the query and return all values for a field name from the generated result.
      <U> @NotNull Set<U> fetchSet​(Name fieldName, Converter<?,​? extends U> converter)
      Execute the query and return all values for a field name from the generated result.
      <E> @NotNull Set<E> fetchSet​(RecordMapper<? super R,​E> mapper)
      Fetch results into a custom mapper callback.
      R fetchSingle()
      Execute the query and return exactly one resulting record.
      @Nullable Object fetchSingle​(int fieldIndex)
      Execute the query and return exactly one resulting value for a field index from the generated result.
      <U> U 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 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 fetchSingle​(String fieldName)
      Execute the query and return exactly one resulting value for a field name from the generated result.
      <U> U 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 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 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 fetchSingle​(Field<T> field)
      Execute the query and return exactly one resulting value for a field from the generated result.
      <T,​U>
      U
      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 fetchSingle​(Name fieldName)
      Execute the query and return exactly one resulting value for a field name from the generated result.
      <U> U 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 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 fetchSingle​(RecordMapper<? super R,​E> mapper)
      Execute the query and return exactly one resulting value into a custom mapper callback.
      @NotNull Object[] fetchSingleArray()
      Execute the query and return exactly one resulting record as an array
      <E> E fetchSingleInto​(Class<? extends E> type)
      Map resulting records onto a custom type.
      <Z extends Record>
      Z
      fetchSingleInto​(Table<Z> table)
      Map resulting records onto a custom record.
      @NotNull Map<String,​Object> fetchSingleMap()
      Execute the query and return exactly one resulting record as a name/value map.
      @NotNull Stream<R> fetchStream()
      Stream this query.
      <E> @NotNull Stream<E> fetchStreamInto​(Class<? extends E> type)
      Stream this query, mapping records into a custom type.
      <Z extends Record>
      @NotNull Stream<Z>
      fetchStreamInto​(Table<Z> table)
      Stream this query, mapping records into a custom record.
      default void forEach​(Consumer<? super R> action)
      Execute the query using fetch() and pass all results to a consumer.
      @NotNull Iterator<R> iterator()
      Execute the query using fetch() and return the generated result as an Iterator.
      default @NotNull Spliterator<R> spliterator()
      Execute the query using fetch() and return the generated result as an Spliterator.
      @NotNull Stream<R> stream()
      Stream this query.