# anyFrom

fun <T> anyFrom(subQuery: AbstractQuery<*>): Op<T>

Returns this subquery wrapped in the `ANY` operator. This function is not supported by the SQLite dialect.

inline fun <T : Any> anyFrom(array: Array<T>, delegateType: ColumnType<T>? = null): Op<T>

Returns this array of data wrapped in the `ANY` operator. This function is only supported by PostgreSQL and H2 dialects.

Note If delegateType is left `null`, the base column type associated with storing elements of type T will be resolved according to the internal mapping of the element's type in resolveColumnType.

#### Parameters

array

Converted to a list view backed by the original array to improve performance. Do not mutate the array after passing to this function; if mutation is needed, convert using Array.toList instead.

#### Throws

IllegalStateException

If no column type mapping is found and a delegateType is not provided.

inline fun <T : Any> anyFrom(array: List<T>, delegateType: ColumnType<T>? = null): Op<T>

Returns this list of data wrapped in the `ANY` operator. This function is only supported by PostgreSQL and H2 dialects.

Note If delegateType is left `null`, the base column type associated with storing elements of type T will be resolved according to the internal mapping of the element's type in resolveColumnType.

#### Throws

IllegalStateException

If no column type mapping is found and a delegateType is not provided.

fun <T> anyFrom(table: Table): Op<T>

Returns this table wrapped in the `ANY` operator. This function is only supported by MySQL, PostgreSQL, and H2 dialects.

fun <E, T : List<E>?> anyFrom(expression: Expression<T>): Op<E>

Returns this expression wrapped in the `ANY` operator. This function is only supported by PostgreSQL and H2 dialects.